How do I have a cell calculate based on a portion of another cell

  • Thread starter Thread starter mellen
  • Start date Start date
M

mellen

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?
 
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)
 
Back
Top