cpisthedbb
New Member
- Joined
- Apr 10, 2018
- Messages
- 30
Hi,
New to the forum, and fairly novice Excel user so bear with me if my questions really easy to answer
In cell A1 I have either "N/A" or a value. I want to put a number in cell A2 dependant on the value in A1. It would be as follows
N/A = 1
1-2 = 1
3-4 = 0.5
4+ = 0
Anyone any ideas what this would look like in a formula as I'm struggling to get this to work?
New to the forum, and fairly novice Excel user so bear with me if my questions really easy to answer

In cell A1 I have either "N/A" or a value. I want to put a number in cell A2 dependant on the value in A1. It would be as follows
N/A = 1
1-2 = 1
3-4 = 0.5
4+ = 0
Anyone any ideas what this would look like in a formula as I'm struggling to get this to work?