IF formula
Yes that is what I mean thank you very much.
"John C" wrote:
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(A2A1,A1+INT((A2-A1)/0.05)*0.01*A1,A1)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.
"Confused in Canada" wrote:
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.
|