IF function OK to use?

T

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,
 
Top