So I have two columns with two sets of values. I have a third column with another value. And I have a forth column that I want to return my data into.
What I'm trying to write is an IF statement that says if the value of my third column falls within the values of my first two columns, fill the fourth column with a specific number.
SO:
A-B-C-D
1-4-3-?
A and B have a range between 1 and 4, C is between those two values, so I want it to return the value 2 to D
This is what I wrote, and it doesn't work:
=IF(A1>B1, 2, 0 IF(A<C1, 2, 0))
It says I'm making "too many arguments". I've read some tutorials that say I should use AND (which I have zero experience with), but I've used a nested IF statement to do something similar before.
Anyone have any thoughts?
Thanks!
Bookmarks