Help with Conditional Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Programming Cells - 28 Aug 2006 18:20 GMT

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.

Reply to this Message

David Billigmeier - 28 Aug 2006 18:30 GMT

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

Signature

Regards,
Dave

> I'm trying to create a conditional formula like:
>
[quoted text clipped - 7 lines]
>
> Many thanks for any help.

Reply to this Message

Programming Cells - 28 Aug 2006 19:25 GMT

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.

> hmm, something like this?
>
[quoted text clipped - 12 lines]
> >
> > Many thanks for any help.

Reply to this Message

David Billigmeier - 28 Aug 2006 19:47 GMT

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.

Signature

Regards,
Dave

> No quite. I had this however, it still populates with the results of Q2 even
> if F2 and G2 are blank.
[quoted text clipped - 17 lines]
> > >
> > > Many thanks for any help.

Reply to this Message

Programming Cells - 28 Aug 2006 20:06 GMT

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.

> 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,
[quoted text clipped - 23 lines]
> > > >
> > > > Many thanks for any help.

Reply to this Message

David Biddulph - 28 Aug 2006 21:18 GMT

...

>> Well, try explaining what you want in english and I'll give you a
>> formula.
[quoted text clipped - 4 lines]
>> trying to
>> do.

> Sorry.
>
[quoted text clipped - 3 lines]
> 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")),"")

Signature

David Biddulph

Reply to this Message