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?

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?