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.net>wrote: > 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