ExcelBanter - Excel "IF" Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel "IF" Formula (https://www.excelbanter.com/excel-discussion-misc-queries/270117-excel-if-formula.html)

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

Quote:

Originally Posted by Babs Pay (Post 964445)

--------------------------------------------------------------------------
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.

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.