london surveyor
New Member
- Joined
- Mar 16, 2006
- Messages
- 8
I would like to be able to identify if a user entered value is equal to a series of calculated figures in my spreadsheet.
I intend to use the IF function but have too many values to state lots and lots of OR options (eg input value = A1, input value =A2, Input value =A3 etc). Is there a neat way of doing it?
The ideal would be to say something along the lines of IF(input value = any of the values in the series (A1:A50), “true”, “false”).
Regards
I intend to use the IF function but have too many values to state lots and lots of OR options (eg input value = A1, input value =A2, Input value =A3 etc). Is there a neat way of doing it?
The ideal would be to say something along the lines of IF(input value = any of the values in the series (A1:A50), “true”, “false”).
Regards