View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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!