Hi
Is there anyway of setting up a formula that knows when to stop calculating? For example I have a cost of $150 that I want payed over a variable number of months from 1 to 6. Can I set up a formula that shows the cost per month i.e $150 divided by the number of months and then stops calculating when the $150 is reached?
Thanks!
Is there anyway of setting up a formula that knows when to stop calculating? For example I have a cost of $150 that I want payed over a variable number of months from 1 to 6. Can I set up a formula that shows the cost per month i.e $150 divided by the number of months and then stops calculating when the $150 is reached?
Thanks!