formula help

J

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
 
B

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

james

sorry bob that one not working either.


Bob Phillips said:
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




.
 
D

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top