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.