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.

 

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%