Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to make simple formulas
....to keep track of grants and balances for my employees. If anyone is
interested in assisting me let me know. The link to the spreadsheet is below. 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. http://spreadsheets.google.com/pub?k...XtG9uqPWf-QpDA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to make simple formulas
If you are entering hours as a number (rather than a date serial):
=IF(A1<1,0,IF(A1<40,1,IF(A1<80,2,IF(A1<120,3,"-")))) I don't know why you would want 3 separate formulas, but perhaps =if(And(A1=80,A1<120),"3 weeks","") =if(And(A1=40,A1<80),"2 weeks","") =if(And(A1=1,A1<40),"1 week","") -- Regards, Tom Ogilvy wrote in message ups.com... ...to keep track of grants and balances for my employees. If anyone is interested in assisting me let me know. The link to the spreadsheet is below. 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. http://spreadsheets.google.com/pub?k...XtG9uqPWf-QpDA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to make simple formulas
I used Tom's sugestion and it worked great but I wanted to thank you
for your time. On Jan 1, 12:21 pm, "Don Guillett" wrote: try =ROUNDUP(E1/40,0) -- Don Guillett SalesAid Software wrote in oglegroups.com... ...to keep track of grants and balances for my employees. If anyone is interested in assisting me let me know. The link to the spreadsheet is below. 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. http://spreadsheets.google.com/pub?k...tG9uqPWf-QpDA- Hide quoted text -- Show quoted text - |
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 | |||
Looking to make some simple formulas... | Excel Programming | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
how do I make a simple macro | Excel Programming |