| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for 55% of a cell reference cannot exceed 156?
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 pcue1490 wrote: Thank You! Is this considered a conditional formula? "Bob Umlas" wrote: =MIN(156,55%*C1) "pcue1490" wrote in message ... 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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Threaded Mode
