rjwalker2514
New member
- Joined
- Aug 25, 2018
- Messages
- 11
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I would like a formula to produce a value based on a measurement range
Example:
If I enter into cell A1 any value from 0.1 to 2.4 inclusive I would like cell A2 to show 400.
If I enter into cell A1 any value from 2.5 to 4.0 inclusive I would like cell A2 to show 600.
All measurements are to one decimal place
Any help greatly appreciated
Example:
If I enter into cell A1 any value from 0.1 to 2.4 inclusive I would like cell A2 to show 400.
If I enter into cell A1 any value from 2.5 to 4.0 inclusive I would like cell A2 to show 600.
All measurements are to one decimal place
Any help greatly appreciated