Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
Count if on Single Criteria with multiply conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |