Help with Conditional Formula
I'm trying to create a conditional formula like:
=IF(OR(F2="Change",F2="New")*AND(G2="Auto CU")*AND(Q2=1),150,IF(Q2=2,200))
It works; however, if F2 is blank it still puts in the results either for
Q2=1 or Q2=2
How can I solve this. If there is no entry in F2 then I would want a
"Blank" result passed.
Many thanks for any help.
|