Hi,
I need a formula that will return a specific text, based upon multiple cells meeting a single critera.
In Cell F2 I need a formula that will return the result "Exception", when the information in cells B2, C2, D2 &
E2 are all >= 5%, if they are less than this then it needs to leave the cell blank
A B C D E F
2 12% -1% -2% -9%
3 14% -20% 6% -19%
4 13% 6% -9% -11%
5 -4% -6% -18% -14%
6 -23% -7% 44% 28%
Any assistance is greatly appreciated, I know it is probably very simple but am banging my head against the wall!
Thanks,
Bookmarks