| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have a cell calculate based on a portion of another cell
I am trying to set up a cell that will claculate a percentage of indirect
costs based on the first $25K of a previosu cell. Any advice on how to create a formula that will calculate based on a portion of another cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I have a cell calculate based on a portion of another cell
based on the first $25K of a previosu cell.
When you refer to the above express it like this in your formula (assuming cell A1 contains the number): MIN(25000,A1) -- Biff Microsoft Excel MVP "mellen" wrote in message ... I am trying to set up a cell that will claculate a percentage of indirect costs based on the first $25K of a previosu cell. Any advice on how to create a formula that will calculate based on a portion of another cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to calculate results in one cell, based on data of another | Excel Discussion (Misc queries) | |||
| Calculate Value on new cell based on List | New Users to Excel | |||
| Calculate the number of weeksdays based on a cell value | Excel Worksheet Functions | |||
| IF statement to calculate based on cell values | Excel Worksheet Functions | |||
| formaula used to abstract portion of a cell to another cell | Excel Worksheet Functions | |||
Linear Mode
