| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apply a percentage factor to a base number
Hi,
A1= percentage B1= Base number Try this formula =B1+B1*A1 Format as number Mike "Southern Kiwi" wrote: I am wanting to do this: Cell A contains a percentage, sometimes negative, sometimes positive. (cell A by necessity is formatted as a percentage) Cell B contains the "base figure" which I want to apply that % to. Cell 3 is to contain the answer. If cell A is positive I want that percentage added to cell B, if it's negative I want it subtracted. Thanks for any help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Apply a percentage factor to a base number
"Southern Kiwi" wrote: I am wanting to do this: Cell A contains a percentage, sometimes negative, sometimes positive. (cell A by necessity is formatted as a percentage) Cell B contains the "base figure" which I want to apply that % to. Cell 3 is to contain the answer. If cell A is positive I want that percentage added to cell B, if it's negative I want it subtracted. Thanks for any help Mike H wrote: Hi, A1= percentage B1= Base number Try this formula =B1+B1*A1 Format as number Mike Thanks, I'll try that at work this morning, the only thing is I am trying to leave Cell A formatted as a % as about 4 other cells are dependant on it. I will feedback how I get on tonight. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply a percentage factor to a base number | Excel Worksheet Functions | |||
| How do I apply icon sets to percentage values in Excel worksheet? | Excel Worksheet Functions | |||
| Round Up by a factor not by a digit [MROUNDUP(number,multiple)] | Excel Worksheet Functions | |||
| How do I set the number format to Base 12? | Excel Discussion (Misc queries) | |||
| Can you change the base number from 100 to something else with %'s | Excel Worksheet Functions | |||
Linear Mode
