Multiply with conditions

S

Stuart

Hi,

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

C1 * D1 = E1

where:

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

Bob Phillips

=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))
 
Top