Hi Experts,
please can you help me with this formula & what is the logic error in this
IF(OR(G2<>"",AND(G2<>"No",D2>8000)),E2,"") -- > Does not work when G2 is Null or G2 is NO
IF((OR(G2<>"No", G2<>"",AND(D5>8000))),F2,"") -->Does not work when G2 is Null or G2 is NO
I have attached the sample sheet. Your help would be appreciated.
Thanks a ton
Bookmarks