How do I set up a range within a IF function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a range within an IF function for specific cell reference.
For example if I have a range from 2.5 to 3.0 I want =IF(A2>=2.5,"B2",0) as
well as =IF(A2<=3.0,"B2",0) in the same A2 cell. Excel always tell me I have
too many arguments. It seems simple to get a range. I know it can be done
with COUNTIF and SUMIF but I don't how with IF. Please help.
 
Back
Top