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!
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
- Hi Martin,
Thanks for the reply, unfortunately it isn't quite the silver bullet I was hoping for. What I was hoping for was a formula (if one exists) that will allow me to add a no less than and a no more than answer.
For example, I know the following formula =MIN(750,E35*0.25%) will ensure the answer is no more than 750 but how do I also ensure in the same formula the answer is no less than zero?
Thanks in advance for your help
James