Adding an IF statement into an existing IF OR statement

I need to add an IF statement into an existing IF OR statement so that the eligibility checker doesn't run until the last fillable field has an input.

Existing IF OR statement: Cell H36
=IF(OR(C7="Yes",C21="Yes"),(1+E36),"-")

IF statement that needs to be added to the existing IF OR statment:
=IF(E36="","-",E36)

Could someone please assist with figuring this out? I'm not sure what needs to happen.

Excel Forum Example.xlsx

Originally Posted by Aardigspook

If I understand you correctly, you want the total family size to be shown only if either C7 or C21 is 'Yes'?
Try this:

Formula:

Please Login or Register  to view this content.

Does that do what you want?

Thank you for taking the time to work on this. The premise you stated above is correct, but in addition, I don't want anything in H36 to be visable until E36 has an entered input. This would allow the user to input all their income data without the status of "undetermined" changing until the end; less confusion this way I believe.

Hi,

In H36:

Formula:

Please Login or Register  to view this content.

See attached.

It worked Jtakw! Thank you so much for the help.