| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel "IF" Formula
I am trying to input a formula but keep getting an error message
I put this in and it works but its not what I want as it does not work for every senario =IF(I450,((I45*1%)+(D45+E45)*11%),(C19-476)*11%), but I really want another IF statement in there because if C19 is less than 476 I want it to return a zero What I want the formula to do is to look at cell I45 and if its great than zero to multiply cell I45 by 1% and add to that result the product of D45+E45 multiplied by 11% If it is not greater than zero I want it to look at cell C19 and see if it is greater than 476 and if it is I want it to calculate the value of cell C19 minus 476 multiplied by 11% if cell C19 is less than 476 I want it to return zero. Can any one help me please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula for an "if" "then" scenario linking 3 worksheets | Excel Discussion (Misc queries) | |||
| How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
| Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
