Help with Conditional Formula

[Guest]

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.

 

[Guest]

hmm, something like this?

=IF(OR(F2="",ISBLANK(F2)),"",IF(OR(F2="Change",F2="New")*(G2="Auto
CU")*(Q2=1),150,IF(Q2=2,200,"no conditions fully met")))

 

[Guest]

No quite. I had this however, it still populates with the results of Q2 even
if F2 and G2 are blank.

I'm going nuts.

 

[Guest]

Well, try explaining what you want in english and I'll give you a formula.
Be sure to include every condition.. e.g. where the formula is to be placed,
what cells need to be checked for blanks, etc. It may help to give all
possible input/output combinations so I can see what exactly you're trying to
do.

 

[Guest]

Sorry.

If F2 is blank then no calculations. If F2 contains "Change or New" then
look at G2. If G2 contains "Auto CU" then look at Q2. If G2 contains
anything else, even blank, then no calculation. If Q2 contains a 1 then 150
if Q2 contains a 2 then 200.

 

[David Biddulph]

message
....

Sorry.

If F2 is blank then no calculations. If F2 contains "Change or New" then
look at G2. If G2 contains "Auto CU" then look at Q2. If G2 contains
anything else, even blank, then no calculation. If Q2 contains a 1 then
150
if Q2 contains a 2 then 200.

=IF(AND(OR(F2="Change",F2="New"),G2="Auto
CU"),IF(Q2=1,150,IF(Q2=2,200,"result undefined")),"")