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