I’m having trouble with an IF statement in Google Sheets that works perfectly in Excel but acts weird in Google Sheets.
My formula is: =IF((B3<(2*C3)),"REORDER","SUFFICIENT")
The problem is that it calculates correctly only in the first row. When I copy it to other rows or when I change the values in columns B3 or C3, the formula doesn’t update the results properly.
I’ve tried several things to fix this issue. I copied the working formula from the first row to fill other rows but that didn’t help. I also tried using semicolons instead of commas in the formula syntax. Even when I created a simpler test formula like IF(B3<C3,"YES","NO") in a different column, it has the same problem.
What’s really strange is that when I download the Google Sheets file and open it in Excel on my computer, everything works perfectly. But when I upload it back to Google Sheets, the problem comes back.
Has anyone experienced this kind of issue with Google Sheets formulas not refreshing properly?
I had the same problem with conditional formulas across multiple rows. Google Sheets was messing up the relative references when I copied the formula down - some cell references got locked when they shouldn’t have. Instead of copying row by row, try an array formula for the whole column: =ArrayFormula(IF(B3:B<(2*C3:C),"REORDER","SUFFICIENT")). This makes Sheets recalculate everything at once instead of cell by cell. I’ve noticed regular IF formulas get wonky when data changes frequently, but array formulas stay consistent.
yeah, i had the same problem b4. make sure your sheets settings have auto-calculate on. sometimes refreshing the page solves it! if not, just try rewriting the formula in a new cell.
This sounds like a circular reference issue I’ve hit before. Google Sheets gets stuck when formulas reference cells that create a dependency loop back to your IF statement. Check if any referenced cells have formulas that might be causing this circular reference. What worked for me was clearing all formatting in those cells, then reapplying the formula. Sometimes Google Sheets’ cache gets corrupted and you need to force a recalculation - select your entire formula range and hit Ctrl+Shift+F9. Since it works in Excel but not Google Sheets, there’s probably a difference in how each platform handles calculation order.