•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I show the variance between 2 numbers when there's 2 other variables
I'm trying to make the variance column show the difference between the "original projection"
and "Actual cost" + "outstanding balance" the part that I can't get working right is that if there's anything in the current outstanding cell the variance can't show as positive. it needs to read 0, If there's something in the adjusted it needs to show the difference over or under while still accounting for the actual cost.
Using Office 365.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#variance
#original projection
#actual cost
#outstanding balance
#difference
#adjusted
#cost
#Office 365
#outstanding
#balance
#projection
#current outstanding cell
#column
#show the difference
#formula