View Single Post
  #1   Report Post  
Babs Pay Babs Pay is offline
Junior Member
 
Posts: 1
Unhappy 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