wrt1mea
asked on
I need to update the following formula
I am trying to come up with an IF statement to look at column A and see if its between two numbers...
=IFERROR(IF(2000<=$A2>=100
What I am using doesnt seem to be working correctly. I have tried to swap the < >, but it doesnt seem to work.
=IFERROR(IF(2000<=$A2>=100
What I am using doesnt seem to be working correctly. I have tried to swap the < >, but it doesnt seem to work.
Last Comment
Or...
=IF(AND($A2>=1000,$A2<=200
because you don't need to worry about #DIV/0 if A2 is always between 1000 and 2000.
Kevin
=IF(AND($A2>=1000,$A2<=200
because you don't need to worry about #DIV/0 if A2 is always between 1000 and 2000.
Kevin
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Works great!!!
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Kevin