Nested if statement

[Former Member]

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

[Former Member · Accepted solution]

The following should work

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

else

if Days worked >=3600 and Days worked< 3630 then 10

else

if Days worked >= 5400 and Days worked < 5430 then 15

regards,

Raghavendra.G