Hi,
=F24/(1-F25)
In above formula (1-F25) will give you 35%. So basically you are dividing
$18.25 by 35%. It will give you the value of 100% (i.e. if $18.25 is 35%
then what is 100%)
For ex: If I purchase xyz product for $18.25 with 65% discount on it. Now I
want to calculate the original price of product.
For this I will use above formula [$18.25 / (100%-65%) or $18.25 / (1-65%)].
It will give me the original price of the xyz product (before deducting 65%
discount).
I hope you got it.
I know some one can explain more easily than this.
Regards,
Swapnil.
On Fri, May 28, 2010 at 12:15 AM, markndawoods markndawo...@molalla.netwrote:
what is this formula designed to provide?
=F24/(1-F25)
where cell F24 is a dollar figure of $18.25
and cell F25 is a percent 65%
It is in a spreadsheet I use at work and am just courious as to what
it is.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe