I need help with a simple formula.
I am trying to come up with a formula for an excel spreadsheet.
What I know is the amount received for a product. Say $261.90. I also know that the fee was 3%. What I want to find out is how much was actually paid. (For this instance it should be $270 but I don't know that yet. That is what I want to find out.)
Any suggestions on a simple formula?
Thank you, CK
Re: I need help with a simple formula.
payed = received / (1 - 3%) = received / 0.97.
Re: I need help with a simple formula.
your wording is quite bad, are you saying it has decreased in value or depreciated over time because 3% of 270 is 261.90
Re: I need help with a simple formula.