formula for 55% of a cell reference cannot exceed 156?

P

pcue1490

I am trying to set up a formula in Excel 2000 to determine paycheck
deductions.
A+B=C
55% of C cannot exceed $156.00 If it does exceed $156.00, I would like the
cell to read $156.00
Thanks for any help!
 
B

bj

I am not 100 % sure I know what you want

do you want the value of C

=min(A1-B1,156/.55)

or do you want 55% of C to show?

=min(.55*(A1-B1),$156.00)

or do you want A-B to show unless the 55 % of A-B is greater than 156

=if(.55*(A1-B1)>156, 156,(A1-B1)
 
P

Pete_UK

You could re-write Bob's formula as:

=IF(55%*C1<156,55%*C1,156)

if you specifically want to make it a conditional formula, but I think
you will agree that the MIN function is easier to type.

Hope this helps.

Pete
 
Top