Combining multiple IF statements

haye.kesteloo108281

Please help me solve the following

The user fills in miles driven per day.

Miles per day is x

1. Less than 101 miles per day = x * 0.33

2. More than 100 but less than 1001 miles per day = x * 0.30 

3. More than 1000 miles per day = x * 0.25

 

I have the 1st and 3rd ones solved

1. =IF(AND(Miles2 < 101), Miles2 * 0.33)

3. =IF(AND(Miles2 > 1000), Miles2 * 0.25)

 

However, I have trouble with the middle one and also how to combine all three conditions into one formula. 

I'm new to Smartsheet. Any help would be much appreciated!

 

Thanks,

Haye

 

 

 

 

haye.kesteloo108281

ok - solved the middle one:

=IF(AND(Miles3 > 100, Miles3 < 1001), Miles3 * 2)

Now I need it all in one formula...