Num error #3

G

Guest

Unable to return a zero if FALSE

=IF(OR(G38=5.5,G38=6,G38=6.5,G38=7,G38=7.5),((VLOOKUP(G38,CU142:CZ158,4,FALSE)-(J38*11))/((N38)-(M38))),

IF(OR(G38=9,G38=9.5,G38=10,G38=11,G38=12),((VLOOKUP(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))))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Num Error #2 2
NUM Error 1
Combining a OR and a AND in an IF statement 3
Formula for taking text out of column B and placing it into column 1
Formula for formatting rows and columns minimizing the outcome. 1
getting value filtering series of data 6
Easiest way to find differences between Rows? 3
Summing Rows Using Macros 3

Top