danielryle
New Member
- Joined
- Mar 2, 2022
- Messages
- 9
- Office Version
- 365
- 2021
- Platform
- Windows
Hi all,
Relative beginner here, sorry!
I currently have a formula that is producing the result I need,
'=IF(E10>=30,"3",IF(E10>=23,"2",IF(E10<23,"1", "")))'
However if the cell contains text or is blank as shown above, I would like the resulting cell to be empty. How do I change my current formula to achieve this.
Many thanks,
Dan
Relative beginner here, sorry!
I currently have a formula that is producing the result I need,
'=IF(E10>=30,"3",IF(E10>=23,"2",IF(E10<23,"1", "")))'
However if the cell contains text or is blank as shown above, I would like the resulting cell to be empty. How do I change my current formula to achieve this.
Many thanks,
Dan