#VALUE! error

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I'm sorry but I added to this formula and it started with the #VALUE!
again. The error goes away once I enter data. It's just so tacky
looking seeing all these error messages. Please help!
=IF(OR(B3="",D3="",B3>D3),"",'Tank Sizes'!$F$15)*(2/98)*F3/D3
 
You have your closing parenthesis for the IF function right after the "$F$15
reference which means the division by D3 is not controlled by the IF
function's testing for D3="". I think moving the parenthesis to the end of
the calculation will yield the result you want...

=IF(OR(B3="",D3="",B3>D3),"",'Tank Sizes'!$F$15*(2/98)*F3/D3)

Since 2/98 is the same as 1/49, you can reduce your formula slightly...

=IF(OR(B3="",D3="",B3>D3),"",'Tank Sizes'!$F$15*F3/D3/49)
 
Back
Top