IF formula
 

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.

IF formula
 

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.

IF formula
 

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

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

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

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.

IF formula
 

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.

"Mike H" wrote:

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

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

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