let's say i want to change the total into the number "9280", and then the "Amount" cells to change into a corresponding order so that it equals to 9280 as well as the numbers in "Days". I know it's a bit confusing but i don't know how to formulate it.What does "reverse of the total" mean?
This is a list of
days x rate = amount
and then the amounts are totaled. "Reverse of the total" doesn't really mean anything. What is the result that you want?
I think your explanation is confusing because you have not thoroughly thought through what your requirements are.let's say i want to change the total into the number "9280", and then the "Amount" cells to change into a corresponding order so that it equals to 9280 as well as the numbers in "Days". I know it's a bit confusing but i don't know how to formulate it.