formula help

[james]

=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

 

[Bob Phillips]

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)

 

[james]

i want to ignor if item not selected, but why is it working in the other
formuals?

 

[james]

sorry bob that one not working either.

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




.

 

[David Biddulph]

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

 

[OLY]

sorry bob that one not working either.







- Show quoted text -

I believe this would work: Just make sure you get the right number of
parentheses.

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

OLY