Skip to Content
0
Former Member
Nov 30, 2009 at 06:16 PM

Nested if statement

23 Views

What's the best approach to capture the following:

if Days worked is >= 1800 and < 1830 then 5

else

if Days worked >=3600 and < 3630 then 10

else

if Days worked >= 5400 and 5430 then 15

Right now it doesn't like the AND operator and throws an Error.

Thanks