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.

Help with Conditional Formula
 

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

--
Regards,
Dave


"Programming Cells" wrote:

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.

Help with Conditional Formula
 

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.


"David Billigmeier" wrote:

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

--
Regards,
Dave


"Programming Cells" wrote:

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.

Help with Conditional Formula
 

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.

--
Regards,
Dave


"Programming Cells" wrote:

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.


"David Billigmeier" wrote:

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

--
Regards,
Dave


"Programming Cells" wrote:

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.

Help with Conditional Formula
 

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 Billigmeier" wrote:

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.

--
Regards,
Dave


"Programming Cells" wrote:

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.


"David Billigmeier" wrote:

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

--
Regards,
Dave


"Programming Cells" wrote:

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.

Help with Conditional Formula
 

"Programming Cells" wrote in
message ...

....
"David Billigmeier" wrote:

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.

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")),"")
--
David Biddulph