Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to make some simple formulas...
....to keep track of grants and balances for my employees. If anyone is
interested in assisting mr let me know and I will show th spreadsheet. I basically want three formulas: *If less than 120 hours but over 80 hours = 3 weeks vacation *If less than 80 hours but over 40 hours = 2 weeks vacation *If less than 40 hours but over 1 hour = 1 week vacation It is the second formula that is giving me the problem. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to make some simple formulas...
=(A1<120)*(A180)*3+(A140)*(A1<80)*2+(A1<40)*(A1 1)*1
-- Gary''s Student " wrote: ....to keep track of grants and balances for my employees. If anyone is interested in assisting mr let me know and I will show th spreadsheet. I basically want three formulas: *If less than 120 hours but over 80 hours = 3 weeks vacation *If less than 80 hours but over 40 hours = 2 weeks vacation *If less than 40 hours but over 1 hour = 1 week vacation It is the second formula that is giving me the problem. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to make some simple formulas...
Maybe another option:
=(--(A11)+(A140)+(A180))*ISNUMBER(A1) If there is no chance for Text, the ISNUMBER can be dropped. -- Dana DeLouis Windows XP & Office 2003 "Gary''s Student" wrote in message ... =(A1<120)*(A180)*3+(A140)*(A1<80)*2+(A1<40)*(A1 1)*1 -- Gary''s Student " wrote: ....to keep track of grants and balances for my employees. If anyone is interested in assisting mr let me know and I will show th spreadsheet. I basically want three formulas: *If less than 120 hours but over 80 hours = 3 weeks vacation *If less than 80 hours but over 40 hours = 2 weeks vacation *If less than 40 hours but over 1 hour = 1 week vacation It is the second formula that is giving me the problem. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP!!! I need to make a simple formula! | Excel Discussion (Misc queries) | |||
Make it Simple! | Excel Worksheet Functions | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
How can I make a simple database. | Excel Programming | |||
how do I make a simple macro | Excel Programming |