IF formula returning me #VALUE??

[Tybudd]

Doesn't make much since to me

=IF(N9="","",+VLOOKUP(N9,BoxWeight,5,FALSE))*P9

If there is data in the N9 cell, it goes ahead and continues the Vlookup, but it it is blank which I assume "" should always be, I get the #VALUE in the cell.
My logic says after the first logic is true, it should just return as "" and leave the cell blank, but strange enough if I eliminate the *P9 at the end it eliminates the #VALUE when the first argument is true, but of course in this situation if it is false then my equation will be incomplete w/o the *P9, help plz.

 

[Rick Rothstein]

Maybe this formula instead...

=IFERROR(VLOOKUP(N9,BoxWeight,5,FALSE)*P9,"")

 

[Tybudd]

Thanks, that does seem to work, but for my knowledge why is it that my formula didn't work, aren't the arguments read from left to right?

 

[Aladin Akyurek]

The formula should be:

=IF(N9="","",VLOOKUP(N9,BoxWeight,5,FALSE)*P9)

Otherwise, you are multiplying P9 with a text value (i.e., "") while unjustified.

 

[Tybudd]

The formula should be:

=IF(N9="","",VLOOKUP(N9,BoxWeight,5,FALSE)*P9)

Otherwise, you are multiplying P9 with a text value (i.e., "") while unjustified.

thanks

 

[Aladin Akyurek]

thanks

You are welcome.