formula help
 

=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

formula help
 

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

formula help
 

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


"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


.

formula help
 

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


.

formula help
 

"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


.

formula help
 

On Oct 21, 9:43*am, james wrote:
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

.- Hide quoted text -

- 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