Forum Discussion
Solved
Nested IF formula in Excel 365
Hello, Im having problems getting the right syntax for nexting IF statements. Basically Im comparing values already placed into cells G5, H5 and I5 to return a value placed into cell E5. This is th...
please see screenshot and file attached.
The formula that I used is an array formula. To make the formula to work, you need to do CTRL+SHIFT+ENTER after you finish writing it or after you edit it in the formula bar. The formula will get curly brackets at the beginning and ending after you hit those three keys.
Good luck!
A different strategy that uses table lookups to determine the training category.
That's the type of information we needed. I believe DanGreene now has a few solutions that can be implemented according to preference. Good luck!