•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can't get rid of inconsistent formula error
Hey guys, I need to get rid of these inconsistent formula green triangles but when I click ignore error and reopen the file, they appear again. Excel thinks that cell should follow formula of a row but it actually follows the logic of a column and should stay that way. Can I do anything about it?
AI suggested modifying the formula to trick Excel into thinking it doesn't need to follow the row logic but none of the modifications worked. I can turn off checking for inconsistency, but I was requested to remove these triangles by a stakeholder and I can't control his computer.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#AI formula generation techniques
#Excel compatibility
#row zero
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#inconsistent formula
#green triangles
#Excel
#formula modification
#row logic
#column logic
#ignore error
#checking for inconsistency
#formula error
#stakeholder request
#trick Excel
#Excel error
#modifications