IF Formulas

[narrowgate88]

Is there a way to get the "then" part of the if formula to be another formula? I have the following formula which isn't working.

Please Login or Register  to view this content.

Basically, I'm wanting the index formula to run if h10 and i10 are not 0. Right now I have "Single" as my "else", but I would like to put a formula in that spot too.

[Paul]

Hi Narrowgate,

You can surely use other functions within an IF function as the True or False arguments. In your example, just remove your second "=" sign.

=IF(AND(H10<>0,I10<>0),INDEX(JointTable2008,MATCH(H10,Spouse1,0),MATCH(I10,Spouse2,0)),"Single")

[narrowgate88]

Worked perfectly. Figures it would be something so simple.

Thank you!