Multiply with conditions

  • Thread starter Thread starter Stuart
  • Start date Start date
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.
 
=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
Merging cells and formats 8
Baffeling IF statement 7
Funtions return wrong result BUG in Execel ??? 8
I need to do a calculation based on the values in two cells 2
MIN Function with arguments 9
increasing or decreasing a cell 16
Combining several cells into single equasion? 1

Back
Top