• 511K Members
• 4,908 Online
• 608K Conversations

## Excel "IF" formula in two different cells only one if not calculating correctly.

Occasional Visitor

# Excel "IF" formula in two different cells only one if not calculating correctly.

I have the same formula in 2 different cells, one returns the correct value of 30 and the other does not. I need help with the formula, please. File attached.

2 Replies

# Re: Excel "IF" formula in two different cells only one if not calculating correctly.

Hello,

While it does that ... Your formula is not the same. One refers to J20 and the other one refers to L20.

# Re: Excel "IF" formula in two different cells only one if not calculating correctly.

Soooo, the file has finally opened. You did not say which cells contain the formulas you refer to, so I'm guessing.

M20 =IF(L20<>"",IF(\$I20=L20,\$G\$18+\$D20,0),"") This returns 30, because the condition of the nested IF is true. I20 = L20 (both cells contain "NE Patriots")

K20 =IF(J20<>"",IF(\$I20=J20,\$G\$18+\$D20,0),"") This returns 0 because the condition of the nested IF is false. I20 is not = J20. I20 has "NE Patriots" and J20 has "Baltimore"

You could have posted just the few cells involved instead of a 3MB  workbook. Also, it would have helped if you named the cells that have the problem. Don't make it harder than necessary to help you. Just saying.

Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies