Forum Discussion
Exel formula needed
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?Hi James,
Please see attached document again. I have generated two options. One with an intermediate row of only the fee, which I then sum in a Final Amount row and another option directly calculating the Final Amount. Hope this is what you were expecting.
Martin