ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   more than 7 nested if (https://www.excelbanter.com/excel-programming/384624-more-than-7-nested-if.html)

[email protected]

more than 7 nested if
 
Can someone help me to make the following formula work.

=IF(H8-$H$7<0.041,H8+$O$21, "")& IF(H8-$H$7<0.0826,H8+$O$22, "")&
IF(H8-$H$7<0.1243,H8+$O$23, "") & IF(H8-$F$7<0.166,H8+$O$24,"")& IF(H8-
$H$7<0.2076,H8+$O$25,"")& IF(H8-$H$7<0.2493,H8+$O$26,"")& IF(H8-$H
$7<0.291,H8+$O$27,"")& IF(H8-$H$7<0.3326,H8+$O$28,"")& IF(H8-$H
$7<0.375,H8+$O$29, "")& IF(H8-$H$7<0.4167,H8+$O$30, "")& IF(H8-$H
$7<0.4583,H8+$O$31, "")&IF(H8-$H$7<0.50,H8+$O$32,
End of day)

Thanks
Shanu



All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com