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

R

RevoProphet

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
How do I install Microsoft Equation 3.0 back to Office 365? 0
Mapping integers to strings 6
COUNTIF with Dates 3
Combine 2 columns in a dynamic range into one 7
VBA for Dependents shortcut menu 0
How to use conditons within a LOOKUP function? 6
Looking to added up based on a character from cell range 1

Top