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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies