Home

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

C_Rose
Occasional Visitor

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. 

Function Arguments.png

2 Replies

Hello,

 

do we really need to see a 3 MB workbook to illustrate your problem? It's downloading extremely slowly. 

 

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

 

Your file has still not finished downloading. 

 

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"

 

2019-01-17_13-44-34.png

 

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
Need FORMULA help please!!
marislav in Excel on
4 Replies
Help with minutes/seconds to seconds.
SteveMorley in Excel on
1 Replies