| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply a % to rows
Assume numbers in A1:M1
In A2 enter =IF(A1="","",A1-(A1*$A$3)) Copy across to M1 Format A3 as percentage then enter your discount percentage like 7.5 in A3 Without formulas...............enter .925 in an empty cell. Copy that cell.........select the range to change and EditPaste SpecialMultiplyOKEsc. Gord Dibben MS Excel MVP On Mon, 25 Aug 2008 13:38:14 -0700, Reza wrote: How can I create a box in excel which would apply to an entire row. What I mean is I want to create an excel sheet for my sales team where they can give discounts. I want to have a box to enter to discount % and the whole row changes. Can anyone help me on this? Thanxs, Reza |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply a heading to two different rows | Excel Worksheet Functions | |||
| How do I apply a formula to multiple rows at the same time? | Excel Worksheet Functions | |||
| setting a formula to apply to all rows in a column | New Users to Excel | |||
| apply formula to other rows ... | Excel Discussion (Misc queries) | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
Threaded Mode
