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 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
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