laura_pink
New Member
- Joined
- Aug 21, 2014
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi,
I need a formula that will return a value to me based on the content of two cells.
Cell A1 contains a number between 0 and 7 to 2 decimal places i.e. 2.5
Cell A2 contains the words 'OK' or 'NOT POSSIBLE'
I need a formula that says that if cell A2 contains 'NOT POSSIBLE', then the answer is always "3E" regardless of what is in A1. If however A2 contains 'OK' and A1 has a value of 1.9 or less the answer is "1", a value of 2.0-2.9 the answer is "2", a value of 3.0-3.9 the answer is "3", a value of 4.0 or more the answer is "3E"
After many hours trying I cannot get anything to work and am now doubtful as to whether there are too many arguments. Any help would be greatly appreciated.
Thanks, Laura
I need a formula that will return a value to me based on the content of two cells.
Cell A1 contains a number between 0 and 7 to 2 decimal places i.e. 2.5
Cell A2 contains the words 'OK' or 'NOT POSSIBLE'
I need a formula that says that if cell A2 contains 'NOT POSSIBLE', then the answer is always "3E" regardless of what is in A1. If however A2 contains 'OK' and A1 has a value of 1.9 or less the answer is "1", a value of 2.0-2.9 the answer is "2", a value of 3.0-3.9 the answer is "3", a value of 4.0 or more the answer is "3E"
After many hours trying I cannot get anything to work and am now doubtful as to whether there are too many arguments. Any help would be greatly appreciated.
Thanks, Laura