Multiply with conditions
 

Hi,

Would appreciate help with a worksheet formula, as follows, please:

C1 * D1 = E1

whe

a) C1 is to be rounded to 2 decimal places
b) ditto for D1
c) do not calculate if either C1 or D1 is blank
d) do not calculate if either C1 or D1 is zero
e) if either C1 or D1 has the word "item", take it as 1 number
f) E1 is to be rounded to 2 decimal places

Is this possible, please?

Regards,
Stuart.

Multiply with conditions
 

=IF(OR(NOT(COUNT(C1)),NOT(COUNT(D1))),"",
ROUND(IF(ISNUMBER(SEARCH("item",C1)),1,ROUND(C1,2) )*IF(ISNUMBER(SEARCH("item",D1)),1,ROUND(D1,2)),2) )

--
__________________________________
HTH

Bob

"Stuart" wrote in message
...
Hi,

Would appreciate help with a worksheet formula, as follows, please:

C1 * D1 = E1

whe

a) C1 is to be rounded to 2 decimal places
b) ditto for D1
c) do not calculate if either C1 or D1 is blank
d) do not calculate if either C1 or D1 is zero
e) if either C1 or D1 has the word "item", take it as 1 number
f) E1 is to be rounded to 2 decimal places

Is this possible, please?

Regards,
Stuart.