Solution to "IF" formula

[Mike Powers]

I'm trying to have a formula in a cell to calculate if another cell states "yes" but if it states "no" (from a dropdown list) then a text of "NF" will result.  I tried by using this formula but it's not working.  Can you help solve?  =IF(H2="No", ["NF"], [=SUM(D2+E2+F2)/C2]); can anyone help me solve?

[#2]

Hi Mike,

This is the correct syntax of the formula:

=IF(H2="No", "NF", SUM(D2+E2+F2)/C2)

Hope that helps

[#3]

Yes sir, it worked!  I'm hoping it will work in my SharePoint list as well.  thanks so much Haytham!