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.

 

Transcribed Image Text:

pi 3212 15.363 6.455 179.905 163.357 276.855 184.96 121.704 6274.614 2531 24.74 sale 42650 135.052 197.317 1545.254 1442.604 2222.588 2234.631 2725.239 39873.91 20247 444.388 txt 330 4.513 -0.102 27.1 36.32 103.812 64.294 43.471 299.694 797 7.759 xrd 7.716 10.514 mkvalt 37405.5843 168.7421 413.2812 2248.9093 2217.1528 2141.3616 2144.9358 2215.9582 4610.182 103271.6885 1345 67891.7357 243.2411 esub 0 0 0 0 0 0 0 0 1.598 spi -956 -0.141 -12.024 -100 0 25.106 -33.317 -37.333 -3155.973 -346 -1.645 sic_2 45 35 35 36 ETR 10.27% 29.38% -1.58% 15.06% 36 22.23% 73 37.50% 73 34.76% 73 35.72% 38 4.78% 38 31.49% 51 31.36% pi 3212 15.363 6.455 179.905 163.357 276.855 184.96 121.704 6274.614 2531 24.74 sale 42650 135.052 197.317 1545.254 1442.604 2222.588 2234.631 2725.239 39873.91 20247 444.388 txt 330 4.513 -0.102 27.1 36.32 103.812 64.294 43.471 299.694 797 7.759 xrd 7.716 10.514 mkvalt 37405.5843 168.7421 413.2812 2248.9093 2217.1528 2141.3616 2144.9358 2215.9582 4610.182 103271.6885 1345 67891.7357 243.2411 esub 0 0 0 0 0 0 0 0 1.598 spi -956 -0.141 -12.024 -100 0 25.106 -33.317 -37.333 -3155.973 -346 -1.645 sic_2 45 35 35 36 ETR 10.27% 29.38% -1.58% 15.06% 36 22.23% 73 37.50% 73 34.76% 73 35.72% 38 4.78% 38 31.49% 51 31.36%

Answer rating: 100% (QA)

Here is the IF formula you can use to limit the ratio between ... View the full answer