Forum Discussion
rach1345
Feb 25, 2023Brass Contributor
IFS FORMULA
Good Afternoon, Could someone please help me with the following formula? The formula reads =IFS(a3="OUTSIDE GRID","OUTSIDE GRID",b3="G1DG","G1DG",c3="GSPECIAL","GSPECIAL") which works but i would li...
- Feb 25, 2023
Does it work if you confirm the formula by pressing Ctrl+Shift+Enter?
rach1345
Feb 25, 2023Brass Contributor
Hi Hans Vogelaar, unfortunately it didn't work :(. It brought up #VALUE error message. Thank you for trying though 🙂
HansVogelaar
Feb 25, 2023MVP
Strange - it works for me. See the attached workbook.