| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula
Thank you - that really helped.
-- Shelly "Gord Dibben" wrote: In C1 enter =MAX((B1-11000),0) In D1 enter =MIN(11000,B1) If B1 contains <11000 you will get 0 in C1 and the amount in D1 If B1 contains 11000 you will get the difference in C1 and 11000 in D1 Gord Dibben MS Excel MVP On Mon, 9 Apr 2007 09:02:02 -0700, Shelly wrote: Ok - I am trying to create a table for my state withholding taxes for payroll for our company. In column b I have the employees quarterly wages, in column c I need it to show how much is excess wages and in column d I would like it to figure the taxable amout which in our state goes up to $11,0000. For example if someone had a quarterly wage of $5850.00, how do I get column d to show that total amount because it is less than and not equal to $11,000 and column c to show 0 because there is no excess at that time. Does this make more sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
