| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apply a percentage factor to a base number
=B1*(1+A1)
-- Gary''s Student - gsnu2007j |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Apply a percentage factor to a base number
Gary''s Student wrote:
=B1*(1+A1) Gee that seems so simple compared to what I have been trying to do (using if statements to differentiate between positive & negative) Thanks for the help, I'll feedback tonight |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 automatically add 1 day to a base number every day? | 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
