If formula

[mhill3514]

I am working on a household inventory spreadsheet. It contains; the item, age and life of the item, replacement cost, the depreciation of the item (age divided by life) and the actual cash value of the item. My problem is with the depreciation. I need to cap it at 75%, so if an item has depreciated more than 75%, I need it to it to be 75%.

 

[T. Valko]

I am working on a household inventory spreadsheet. It contains; the item, age and life of the item, replacement cost, the depreciation of the item (age divided by life) and the actual cash value of the item. My problem is with the depreciation. I need to cap it at 75%, so if an item has depreciated more than 75%, I need it to it to be 75%.

Try this...

B2 = age
C2 = life

=MIN(0.75,B2/C2)