Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello! So for column ETR, there needs to be an IF formula embedded into another IF formula. For instance, the calculation is the columns TXT/PI.
Hello! So for column ETR, there needs to be an IF formula embedded into another IF formula. For instance, the calculation is the columns TXT/PI. The ratio needs to be limited between 0 and 1. I need help with the IF formula, please.
txt xrd esub spi sic_2 pi 3212 15.363 mkvalt 37405.5843 330 -956 45 sale 42650 135.052 197.317 4.513 168.7421 0 35 -0.102 0 -0.141 -12.024 -100 35 0 7.716 10.514 0 0 6.455 179.905 163.357 276.855 184.96 121.704 6274.614 36 36 73 0 1545.254 1442.604 2222.588 2234.631 2725.239 39873.91 20247 444.388 27.1 36.32 103.812 64.294 43.471 299.694 ETR 10.27% 29.38% -1.58% 15.06% 22.23% 37.50% 34.76% 35.72% 4.78% 31.49% 31.36% 413.2812 2248.9093 2217.1528 2141.3616 2144.9358 2215.9582 103271.6885 67891.7357 243.2411 0 0 25.106 -33.317 -37.333 -3155.973 -346 -1.645 73 73 38 0 4610.182 1345 2531 797 38 51 24.74 7.759 1.598 txt xrd esub spi sic_2 pi 3212 15.363 mkvalt 37405.5843 330 -956 45 sale 42650 135.052 197.317 4.513 168.7421 0 35 -0.102 0 -0.141 -12.024 -100 35 0 7.716 10.514 0 0 6.455 179.905 163.357 276.855 184.96 121.704 6274.614 36 36 73 0 1545.254 1442.604 2222.588 2234.631 2725.239 39873.91 20247 444.388 27.1 36.32 103.812 64.294 43.471 299.694 ETR 10.27% 29.38% -1.58% 15.06% 22.23% 37.50% 34.76% 35.72% 4.78% 31.49% 31.36% 413.2812 2248.9093 2217.1528 2141.3616 2144.9358 2215.9582 103271.6885 67891.7357 243.2411 0 0 25.106 -33.317 -37.333 -3155.973 -346 -1.645 73 73 38 0 4610.182 1345 2531 797 38 51 24.74 7.759 1.598
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started