Forum Discussion
hawkins56671
Sep 22, 2017Copper Contributor
Multiple Nested IF functions with additional AND functions
HERE IS WHAT I AM WORKING ON BUT I REALLY JUST NEED AN EXAMPLE OF HOW PROPERLY INPUT THE INFORMATION. I DONT UNDERSTAND HOW THESE TWO FUNCTIONS WORK TOGETHER. Enter nested IF and AND functions to d...
CARLOS ADRIAN
Sep 22, 2017Copper Contributor
I hope it helps
=IF(AND(ISBLANK(H19),ISBLANK(I19)),"",IF(AND(K19="N",H19<=J19),"Rush",IF(AND(K19="N",H19<I19),"Reorder","OK")))
hawkins56671
Sep 22, 2017Copper Contributor
Thanks Carlos
- CARLOS ADRIANSep 22, 2017Copper Contributor
You're welcome, have a nice day and happy weekend