IF function OK to use?
 

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

IF function OK to use?
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom McFadd" wrote in message
...
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,
--
Tom