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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Baffeling IF statement 7
Funtions return wrong result BUG in Execel ??? 8
if and vlookup functions 3
I need to do a calculation based on the values in two cells 2
increasing or decreasing a cell 16
Combining several cells into single equasion? 1
MIN Function with arguments 9

Top