Timesheet IF Statements

[rachellock]

Hi
I am trying to create a timesheet in Excel and need to use the method that
if a contractor works <=1 hour they have worked 0 days, <= 3 hours they have
worked 0.25 days, <= 5 hours they have worked 0.5 days and so on - this works
very well using IF Statements however I have far more than 7 nested
statements?Any solutions?
Help please........

 

[David Biddulph]

VLOOKUP.

 

[Bob Phillips]

Create a table in say K1:Ln like this

..............0..........0.25
....3:00:00...........0.5
....5:00:00...........0.75

etc., and use

=LOOKUP(A1,K1:K6,L1:L6)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[bj]

dont start your nested ifs at 0
=if(hours<5,if(hours<3,if(hours<1,0,.25),.5),if(hours<7,.75,if hours<8,1,if
hours<10 ....))))

with numbers you can normally format your if statement such that you may
have a lot of ifs, but not many levels.