"not working" isn't a very explicit problem description, James, particularly
when Bob asked which of two alternatives you wanted and you didn't answer
his question.

If you want help, it may be wise to say what formula you are using, which
data values, what result you expected, and what result you got.
--
David Biddulph

"james" wrote in message
...
sorry bob that one not working either.


"Bob Phillips" wrote:

Well you would, as it is the same as saying =B49*1.5+0

What do you want, to multiply by the cost per item,

=B49*1.5*J22

or ignore if price per item is not set

=IF(J22="","",B49*1.5+J22)


--
__________________________________
HTH

Bob

"james" wrote in message
...
=B49*1.5+J22

B49 is labour cost per hour, 1.5 is amount of hours, J22 is price per
item,
however when J22 is left blank i am still getting result for B49*1.5.

i am using a similar formula;
=F5*D49+J5
=F49*2*E14+J14
but everything is ok in these cells, result is blank.

thanks everyone
James


.