Forum Discussion
Solved
Exel formula needed
Hi there, I am trying to show a specific fixed annual cost in a spreadsheet each year for a specified period. The cost is shown in a specific cell (D9) but only applies annually for a certain num...
Nice to hear that! Please consider marking the answer as a solution if you think you have solved your issue!
Hi, please see attached document with proposed solution. Is this what you are looking for?
=IF($E$9>=E19,1000+$D$9,1000)
Assuming there is a base amount of 1000 each year (which will be added to the fixed 1500 cost). This can be replaced by any formula you want or whatever value might interest your case.
Martin
Martin_Angosto thanks so much works perfectly - legend!
Nice to hear that! Please consider marking the answer as a solution if you think you have solved your issue!
- Hi there Martin,
I am trying to show a calculation where if the answer is less than zero a zero needs adding (i.e. no less than zero) and if the answer is greater than a certain figure (in this case 600) the max it shows is 600.
For example a value of £400,000 as stated in cell D1 charged at 0.20% this would oridnarily be £800 but this needs capping at £600.00. If the D1 value was was -£150,000 the fee would simply show as zero (rather than -£300). Effectively how do I show a no more than and no less than in the same formula?
Hope this makes sense?
