IF function OK to use?

[Tom McFadd]

I'm tryingfind a function to return one of three prices as below based on a
random qty as below:

Qty 0 to 49,999 = .61
Qty 50,000 to 99,999 = .60
Qty >99,999 = .59

Can the IF function handle this?
Thanks,

 

[Don Guillett]

=if(a1>=100000,.59,if(a1>=50000,.6,if(a1>0,.61,0)))