Looking to make some simple formulas...

B

bjp1965

....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.
 
D

Dana DeLouis

Maybe another option:

=(--(A1>1)+(A1>40)+(A1>80))*ISNUMBER(A1)

If there is no chance for Text, the ISNUMBER can be dropped.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking to make simple formulas 3
Mulitple If Statments 3
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Copy colored cell to a second page 1
Grow/Shrink Text gradually from slide to slide 0
calculating vacation 1
Complex Timesheet 10
Formula for calculating target hours against actual hours 12

Top