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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Search for value in a range 6
Help needed for Excel formula using if, iserr, match and vlookup! 1
Set non-continuous PrintArea via Function / Name 0
SUMIF data that falls within a range 3
SUMPRODUCT Issue 5
COUNTIF with Dates 3
Mapping integers to strings 5

Top