formula for 55% of a cell reference cannot exceed 156?
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)
"pcue1490" wrote:
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!
|