Home |
Search |
Today's Posts |
#1
|
|||
|
|||
wrong syntax
Im trying to do something like this but i havent gotten the right syntax
if c:4 is 300 and <400 subtract 43 and multiply by .36 |
#2
|
|||
|
|||
Hi
2 possible solutions - the first one returns an empty string (or any other result on your choice), when conditions aren't filled, the other returns 0 in this case: =IF(AND(C4300,C4<400),(C4-43)*0.36,"") =AND(C4300,C4<400)*(C4-43)*0.36 Arvi Laanemets "Asta" wrote in message ... Im trying to do something like this but i havent gotten the right syntax if c:4 is 300 and <400 subtract 43 and multiply by .36 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions | |||
Logic statement returns wrong answer. | Excel Worksheet Functions | |||
IF function displays wrong amount | Excel Worksheet Functions |