IF function help

MRomanow

New Member
Joined
Mar 10, 2005
Messages
46
I have an IF function and I want to return a value of 5 if the weight is between 200 and 500 and 1 of any other #.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Are you wanting something like this?

Code:
=IF(AND(A1>=200,A1<=500),5,1)
 

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,251
Members
412,709
Latest member
Rishu
Top