IF AND Nested Functions - Formula Not Working

Feb 22, 2016
Reaction score

I've trying to get several functions in one formula to work. I can get it working with just one.


G61 is a drop down box and have options ranging up to 10+. So for the second option, if it was a lone formula, it would read:

Each number (1, 2, 3, 4, etc) have a different minimum value that needs to shout CHECK if it's below that figure. How do I go about making this into one long, continuous formula without Excel shouting at me?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question