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 |
#2
|
|||
|
|||
Quote:
Dear Babs Pay, Good Afternoon. Try this formula: =IF(I450,((I45*1%)+(D45+E45)*11%),IF(C19=476,(C1 9-476)*11%),0) Tell me if it worked for you.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#3
|
|||
|
|||
If the numbers are formatted as times, you can simply subtract them. The results will be in decimal hours, e.g. half an hour is .5 and 45 minutes is .75 hours. If you have to deal with third shift hours, where a shift ends "before" it begins, add 24 hours.
|
Reply |
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 |