Help with Conditional Formula

P

Programming Cells

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.
 
D

David Billigmeier

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")))
 
P

Programming Cells

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.
 
D

David Billigmeier

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.
 
P

Programming Cells

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.
 
D

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.
Click to expand...

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