Forum Discussion
Solved
Excel calculator dividing numbers into separate cells with a max value
I am trying to create a formula which will divide a number into 3 cells with a max value Context : cancelling invoices by crediting the invoices Example : invoice total is £9000 and needs £7750 to b...
Kw83-124 Perhaps the formulae in the attached file solve your problem.
Riny_van_Eekelen Hi! This is wonderful and exactly what I was looking for, thank you very much. Would you know how to amend this so that it goes from the bottom up too?
Kw83-124 Mmmmmm..... , perhaps the attached file is something you can use. Put all your invoices in a table (with an index column for sorting) and link the "calculator" to the table.