Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula discount
how to use formula discount? "%"
|
#2
|
|||
|
|||
"Discount" can mean a lot of things. One meaning would be to give an x%
discount on a base value. If the base value is in A1 and you want to apply a 10% discount: B1: =A1 * (1 - 10%) or, equivalently B1: =A1 * 90% In article , "need formula as soon as posible" <need formula as soon as wrote: how to use formula discount? "%" |
#3
|
|||
|
|||
Or are talking about the DISC worksheet function. You can find the help on your machine for this function. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=377965 |
#4
|
|||
|
|||
Whatever formulae you end up using I would suggest that the discount rate
"variable" is in a separate cell to which the formula refers. In this way you need only change the discount rate once. The alternative is to change all the formulae at the risk of missing one! Regards. Bill Ridgeway Computer Solutions "need formula as soon as posible" <need formula as soon as wrote in message ... how to use formula discount? "%" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |