Thanks!

--
Krista


"daddylonglegs" wrote:

>
> 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
>
>