| Home |
| Search |
| Today's Posts |
|
#3
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. |
![Confused in Canada[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
