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

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?
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations based on cell colour 6
Two formulas in on cell based on two numbers in another cell? 5
Trying to multiply data by one cell, based on data of another 3
Calculate Amount with Varying Percentages per Thousands 2
Conditional Formatting Question 2
How do I calculate a person's age from date of birth and a date 2
Refering to a cell above another cell 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top