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

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

more than 7 nested if
 

It seems to me this could be made a lot simpler using a lookup table.

Hth,
Merjet

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

more than 7 nested if
 

change End of day to "End of day"?

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

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

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

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...

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