Complicated IF function

[maidenhel]

Hello All,

I am new to this site in hopes of a little help.

Here's the quick scenario:

I have 2 columns that I would like to compare. They start at F4 and G4 respectively. Here's what I am trying to achieve:

IF
F4>0, G4>0 display NO PITCH
F4=0, G4>0 display GAS
F4>0, G4=0 display ELECTRIC
F4=0, G4=0 display DUAL

I have tried tirelessly to get the result column to display correctly, to no avail.

As another challenge, I would like this result to be compared to an additional column, call it E4. There are 3 results in E4, COMBINE, E-RES, G-RES. COMBINE has no effect on the result. E-RES would negate GAS, and turn DUAL into ELECTRIC. G-RES would negate ELECTRIC, and turn DUAL into GAS.

If this second part could be integrated as well, it would so greatly appreciated, but I understand it complicates things quite a bit.

Thank you in advance!

 

[ukmikeb]

i got the answer with a little help at another Excel forum.

this worked:

=IF(E718="E-RES",_IF(G718>0,"NO PITCH","ELECTRIC")_,IF(E718="G-RES",_IF(F718>0,"NO PITCH","GAS")_,IF(F718>0,IF(G718>0,"NO PITCH","ELECTRIC"),IF(G718>0,"GAS","DUAL"))))

Thanks for letting us know that you also double-posted on another site, here -
Complicated IF function [SOLVED]

It would have been courteous to let the users here know that they may have been wasting their time trying to solve your problem.

Forum Rules state that you should advise users of this site that there is post on another site.

 

[maidenhel]

Complicated IF function [SOLVED]