IF formula

  • Thread starter Thread starter Confused in Canada
  • Start date Start date
C

Confused in Canada

I have a spreadsheet in which I need to be able to see if one cell is larger
by increments of 0.05 than add 1% per increment. Is there a formula that
would work, I have tried a couple of different If formulas but can't seem to
come up with the correct one.
 
I am assuming you mean you are checking to see if one cell is larger than
another _cell_ by and for every increment of 0.05 larger, add 1% to it.
so, say A1=1st number, and A2=2nd number
=IF(A2>A1,A1+INT((A2-A1)/0.05)*0.01*A1,A1)
 
Hi,

Your not as confused in Canada as I am in the UK!!
I have a spreadsheet in which I need to be able to see if one cell is larger
by increments of 0.05 than add 1% per increment
Click to expand...

You want to see if one cell is larger than what by 0.05 and where is this
value you want to compare. What do you want to add 1% to?

Mike
 
Yes that is what I mean thank you very much.

John C said:
I am assuming you mean you are checking to see if one cell is larger than
another _cell_ by and for every increment of 0.05 larger, add 1% to it.
so, say A1=1st number, and A2=2nd number
=IF(A2>A1,A1+INT((A2-A1)/0.05)*0.01*A1,A1)
Click to expand...
 
Sorry I said I was confused, I need to see if A1 is larger than A2 by
increments of 0.05 and if it is than add 1% per increment to A1 but thank you
John C answered my question.
 
Back
Top