Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|