Thread: Num error #3
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shu of AZ Shu of AZ is offline
external usenet poster
  
Posts: 130
Default 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))))))
Reply With QuoteReply With Quote