IF statement based on formula value

[AL789]

Could someone help me write an if statement that populates the denominator column based on the criteria in the sample file? I've listed the results I need to achieve in the denominator column as well.

Thanks!!

[#2 · Accepted solution]

@AL789 

I guess that's the same question I answered in another conversation https://techcommunity.microsoft.com/t5/Excel/Help-with-IF-statement/m-p/1074547#M47016

[#3]

Yes thank you!