| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a figure + a percentage after using lesser than or greater
I have a column with an amount in and need a formula to add a figure to this
cell after using less than or greater than, after this to add a percentage after determining the figure, hope this makes sense |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a figure + a percentage after using lesser than or greater
It doesn't make sense, sorry. Give an example with numbers.
Dave -- Brevity is the soul of wit. "stevemel50" wrote: I have a column with an amount in and need a formula to add a figure to this cell after using less than or greater than, after this to add a percentage after determining the figure, hope this makes sense |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a figure + a percentage after using lesser than or grea
sounds sort of like:
I have a cell with a value. If the value is greater than some other value, then divide my x. if less than the other value, divide by y. That's a wild guess. If so: Assuming the original valeu is in cell A2: =if(A2 value,A2/x, A2/y) Of course, I could be completely off the mark. "Dave F" wrote: It doesn't make sense, sorry. Give an example with numbers. Dave -- Brevity is the soul of wit. "stevemel50" wrote: I have a column with an amount in and need a formula to add a figure to this cell after using less than or greater than, after this to add a percentage after determining the figure, hope this makes sense |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to figure out percentage of change for 5 years | Excel Discussion (Misc queries) | |||
| how do i overwrite a cell and keep adding to another figure? | New Users to Excel | |||
| Need to figure out a percentage | Excel Discussion (Misc queries) | |||
| Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
| Adding a column based on greater than a date | Excel Worksheet Functions | |||
Linear Mode
