Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(And - multiple conditions
This is my spreadsheet:
C D H I J Month Start Date End Date June July 5,821.83 1/1/08 5,821.83 I have a formula that looks at a start date and places the monthly salary based on the start date in the appropriate month, and carries it forward for the rest of the year. How do I incorporate an additional statement that also looks at the "End Date" field, and will enter a zero in the last pay month, and subsequent months for the rest of the year? My formula is: =IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,)))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(And - multiple conditions
That did it and I thank you. I do however have to take in to account a half
month salary. I needn't worry about less than that. How can I build that in? "Don Guillett" wrote: Let's change it to name ann salary start date end date jan feb mar joe $10,000.00 14-Jun 2-Oct 0 0 0 put this formula (ONE line) in e2 and copy across and down =IF(AND(COLUMN(A1)=MONTH($C2),COLUMN(A1)<=MONTH($ D2)),DOLLAR($B2/12),0) Does not attempt to use partial months pay. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... This is my spreadsheet: C D H I J Month Start Date End Date June July 5,821.83 1/1/08 5,821.83 I have a formula that looks at a start date and places the monthly salary based on the start date in the appropriate month, and carries it forward for the rest of the year. How do I incorporate an additional statement that also looks at the "End Date" field, and will enter a zero in the last pay month, and subsequent months for the rest of the year? My formula is: =IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,)))) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(And - multiple conditions
Your company is cheap. What criteria do you have for the 1/2 month. Start
month/end month/both. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... That did it and I thank you. I do however have to take in to account a half month salary. I needn't worry about less than that. How can I build that in? "Don Guillett" wrote: Let's change it to name ann salary start date end date jan feb mar joe $10,000.00 14-Jun 2-Oct 0 0 0 put this formula (ONE line) in e2 and copy across and down =IF(AND(COLUMN(A1)=MONTH($C2),COLUMN(A1)<=MONTH($ D2)),DOLLAR($B2/12),0) Does not attempt to use partial months pay. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... This is my spreadsheet: C D H I J Month Start Date End Date June July 5,821.83 1/1/08 5,821.83 I have a formula that looks at a start date and places the monthly salary based on the start date in the appropriate month, and carries it forward for the rest of the year. How do I incorporate an additional statement that also looks at the "End Date" field, and will enter a zero in the last pay month, and subsequent months for the rest of the year? My formula is: =IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,)))) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(And - multiple conditions
Start or end the 15th of the month should give me 1/2 month increments in the
month the event occurs. "Don Guillett" wrote: Your company is cheap. What criteria do you have for the 1/2 month. Start month/end month/both. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... That did it and I thank you. I do however have to take in to account a half month salary. I needn't worry about less than that. How can I build that in? "Don Guillett" wrote: Let's change it to name ann salary start date end date jan feb mar joe $10,000.00 14-Jun 2-Oct 0 0 0 put this formula (ONE line) in e2 and copy across and down =IF(AND(COLUMN(A1)=MONTH($C2),COLUMN(A1)<=MONTH($ D2)),DOLLAR($B2/12),0) Does not attempt to use partial months pay. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... This is my spreadsheet: C D H I J Month Start Date End Date June July 5,821.83 1/1/08 5,821.83 I have a formula that looks at a start date and places the monthly salary based on the start date in the appropriate month, and carries it forward for the rest of the year. How do I incorporate an additional statement that also looks at the "End Date" field, and will enter a zero in the last pay month, and subsequent months for the rest of the year? My formula is: =IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,)))) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(And - multiple conditions
I repeat the question, which event?? start/end/both
-- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... Start or end the 15th of the month should give me 1/2 month increments in the month the event occurs. "Don Guillett" wrote: Your company is cheap. What criteria do you have for the 1/2 month. Start month/end month/both. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... That did it and I thank you. I do however have to take in to account a half month salary. I needn't worry about less than that. How can I build that in? "Don Guillett" wrote: Let's change it to name ann salary start date end date jan feb mar joe $10,000.00 14-Jun 2-Oct 0 0 0 put this formula (ONE line) in e2 and copy across and down =IF(AND(COLUMN(A1)=MONTH($C2),COLUMN(A1)<=MONTH($ D2)),DOLLAR($B2/12),0) Does not attempt to use partial months pay. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... This is my spreadsheet: C D H I J Month Start Date End Date June July 5,821.83 1/1/08 5,821.83 I have a formula that looks at a start date and places the monthly salary based on the start date in the appropriate month, and carries it forward for the rest of the year. How do I incorporate an additional statement that also looks at the "End Date" field, and will enter a zero in the last pay month, and subsequent months for the rest of the year? My formula is: =IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,)))) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(And - multiple conditions
Sorry - both
"Don Guillett" wrote: I repeat the question, which event?? start/end/both -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... Start or end the 15th of the month should give me 1/2 month increments in the month the event occurs. "Don Guillett" wrote: Your company is cheap. What criteria do you have for the 1/2 month. Start month/end month/both. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... That did it and I thank you. I do however have to take in to account a half month salary. I needn't worry about less than that. How can I build that in? "Don Guillett" wrote: Let's change it to name ann salary start date end date jan feb mar joe $10,000.00 14-Jun 2-Oct 0 0 0 put this formula (ONE line) in e2 and copy across and down =IF(AND(COLUMN(A1)=MONTH($C2),COLUMN(A1)<=MONTH($ D2)),DOLLAR($B2/12),0) Does not attempt to use partial months pay. -- Don Guillett Microsoft MVP Excel SalesAid Software "Micki" wrote in message ... This is my spreadsheet: C D H I J Month Start Date End Date June July 5,821.83 1/1/08 5,821.83 I have a formula that looks at a start date and places the monthly salary based on the start date in the appropriate month, and carries it forward for the rest of the year. How do I incorporate an additional statement that also looks at the "End Date" field, and will enter a zero in the last pay month, and subsequent months for the rest of the year? My formula is: =IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,)))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
How do I add multiple values that match multiple conditions? | Excel Discussion (Misc queries) | |||
Multiple conditions and multiple return values | Excel Worksheet Functions | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |