Excel Formulas [Closed]

Report
Posts
1
Registration date
Monday August 30, 2010
Status
Member
Last seen
August 30, 2010
-
 Ray -
Hello,

Please help me with this ?

I know what the percentage being deducted and I know what the end total is, I would just like to know how to work out what the amount is before the percentage is deducted ? Is there a formula for this on Excel ?

eg. ? - 50% = 50

Thank you.

1 reply

Ok:

?=ANSWER/(1-(PERCENT/100))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!