View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom McFadd Tom McFadd is offline
external usenet poster
 
Posts: 1
Default 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