Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF Help | Excel Discussion (Misc queries) | |||
nested if help | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested IF | Excel Discussion (Misc queries) | |||
What is quicker? Nested or non nested ifs | Excel Programming |