Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|