When E15 is blank the IF function does indeed return a blank but then
you are trying to multiply that blank by 4.5, which will give you a
#VALUE! error.

If you always want to multiply the number in E15 (without the "x") by
G15 and then by 4.5 perhaps try

=IF(E15="","",G15*SUBSTITUTE(E15,"x","")*4.5)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=558685