Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Num error #3
Unable to return a zero if FALSE
=IF(OR(G38=5.5,G38=6,G38=6.5,G38=7,G38=7.5),((VLOO KUP(G38,CU142:CZ158,4,FALSE)-(J38*11))/((N38)-(M38))), IF(OR(G38=9,G38=9.5,G38=10,G38=11,G38=12),((VLOOKU P(G38,CU142:CZ158,4,FALSE)-(J38*10.5))/((N38-100+60)-(M38))), IF(OR(G38=8,G38=8.32,G38=8.5),((VLOOKUP(G38,CU142: CZ158,4,FALSE)-(J38*10.5))/((O38-100+60)-(N38)))))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Num error #3
Hi
Check your previous post! Cheers Jean-Guy "Shu of AZ" wrote: Unable to return a zero if FALSE =IF(OR(G38=5.5,G38=6,G38=6.5,G38=7,G38=7.5),((VLOO KUP(G38,CU142:CZ158,4,FALSE)-(J38*11))/((N38)-(M38))), IF(OR(G38=9,G38=9.5,G38=10,G38=11,G38=12),((VLOOKU P(G38,CU142:CZ158,4,FALSE)-(J38*10.5))/((N38-100+60)-(M38))), IF(OR(G38=8,G38=8.32,G38=8.5),((VLOOKUP(G38,CU142: CZ158,4,FALSE)-(J38*10.5))/((O38-100+60)-(N38)))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|