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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
Hi
Can you say what it is supposed to do? Otherwise, how is anyone to know if it works?? regards Paul On Mar 6, 2:26 pm, wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
It seems to me this could be made a lot simpler using a lookup table.
Hth, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
Without commenting on the errors in your formula but trying to see what is
needed, try something like this =H8 + (H8-$H$7<0.041)*$O$21 +(H8-$H$7<0.0826)*$O$22 + (H8-$H$7<0.1243)*$O$23 .....etc best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message ps.com... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
Belay that! It will not work
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message ps.com... 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
Hard to figure out what you want but something like this???
=H8+INDIRECT("o"&INT((H8-H7)/0.0417)+20) -- Don Guillett SalesAid Software wrote in message ps.com... 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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
On Mar 6, 8:06 pm, "Don Guillett" wrote:
Hard to figure out what you want but something like this??? =H8+INDIRECT("o"&INT((H8-H7)/0.0417)+20) -- Don Guillett SalesAid Software wrote in message ps.com... 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- Hide quoted text - - Show quoted text - .. Try this buddy.... =IF(H8-$H$7<0.041,H8+$O$22,"")&IF(H8-$H$7<0.0826,H8+$O$23,"")&IF(H8-$H $7<0.1243,H8+$O$24,"")&IF(H8-$F$7<0.166,H8+$O$25,"")&IF(H8-$H $7<0.2076,H8+$O$26,"")&IF(H8-$H$7<0.2493,H8+$O$27,"")&IF(H8-$H $7<0.291,H8+$O$28,"")&IF(H8-$H$7<0.3326,H8+$O$29,"")&IF(H8-$H $7<0.375,H8+$O$30,"")&IF(H8-$H$7<0.4167,H8+$O$31,"")&IF(H8-$H $7<0.4583,H8+$O$32,"")&IF(H8-$H$7<0.5,H8+$O$33,"End of day") hope this works... |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
more than 7 nested if
Please do not reply ...i made mistake in original formula
I have resend the message as revised nested if and stating my problem thanks for all the responses shanu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested if help | Excel Discussion (Misc queries) | |||
Nested If | 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 |