Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ken
 
Posts: n/a
Default Looking for function or formula to calculate number that is revers

I am looking for formula or function that will help to calculate the number
that can be discounted by percentage back to the original number I have. For
example, my original number is 100, and the discount percent is 40%. I am
looking for a formula that will result in 166.67. Where 166.67 - (166.67 *
40%) will result in my original number of 100.
Another example is Input 100, and Discount 60%, the output of the function
or formula would be 250 (where 250 - (250 * 60%) = 100).
Note that this function is available in some of the business calculator,
label as MU in Citizen calculator.
Does anyone know of a function in excel or a formula where I can achieve this?
Thanks a lot..
  #2   Report Post  
David Flick
 
Posts: n/a
Default

?B?S2Vu?= allegedly wrote in
:

I am looking for formula or function that will help to calculate the
number that can be discounted by percentage back to the original number
I have. For example, my original number is 100, and the discount percent
is 40%. I am looking for a formula that will result in 166.67. Where
166.67 - (166.67 * 40%) will result in my original number of 100.
Another example is Input 100, and Discount 60%, the output of the
function or formula would be 250 (where 250 - (250 * 60%) = 100).
Note that this function is available in some of the business calculator,
label as MU in Citizen calculator.
Does anyone know of a function in excel or a formula where I can achieve
this? Thanks a lot..


I don't know if I completely understand what you are after or if you are just
trying to make this harder than it is, but I have always done =100/60%=
166.67; =100/40%=250. Seems to work for me.
  #3   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

=100/(100%-40%)
or
=100/(1-0.4)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Ken" wrote in message
...
I am looking for formula or function that will help to calculate the

number
that can be discounted by percentage back to the original number I have.

For
example, my original number is 100, and the discount percent is 40%. I am
looking for a formula that will result in 166.67. Where 166.67 - (166.67

*
40%) will result in my original number of 100.
Another example is Input 100, and Discount 60%, the output of the function
or formula would be 250 (where 250 - (250 * 60%) = 100).
Note that this function is available in some of the business calculator,
label as MU in Citizen calculator.
Does anyone know of a function in excel or a formula where I can achieve

this?
Thanks a lot..



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Formula or Function to calculate Margin (reverse of Percent a Ken Excel Worksheet Functions 1 February 7th 05 10:26 AM
How do I replace a negative number at the end of a formula with a. dealn2 Excel Discussion (Misc queries) 5 December 23rd 04 08:47 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
How do you calculate the nth root of a number in Excel 2003? William Excel Worksheet Functions 2 November 17th 04 05:19 PM
Need number of months or weeks passed from formula Cowtoon Excel Worksheet Functions 9 November 12th 04 10:06 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"