Hi all - would be grateful for a little help.
Wanting to write an IF statement which brings back a result based on two conditions but my knowledge is holding me back.
=IF(r2=”Purple”and(t2=”Green”or”Orange”),Vegetables,””))
Where Vegetables is a Range.
Actually wanting to nest it in data validation to bring back an appropriate drop down list.
Hoping you can help. Many thanks.
Bookmarks