1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

why am I getting #Div/0!

https://preview.redd.it/xqnntnja4xlg1.png?width=531&format=png&auto=webp&s=9d9f2709a174e9da90850ff5156e45850a937d06

https://preview.redd.it/0fojcr3g4xlg1.png?width=569&format=png&auto=webp&s=7cdb825c6f1724fa960f4854b89394b2d416995d

I'm trying to subtract a number to this highlighted green formula. I've been trying to subtract it from a cell in another tab, which wasn't working, and now even if I just try to subtract a hard coded number I get the same result. #DIV/0 shows up in this cell and all the other cells connected with these tab no matter what I'm trying. What's going on?

submitted by /u/justonemorepeakmom
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
##DIV/0!
#subtract
#cell
#formula
#hard coded number
#tab
#highlighted green
#connected cells
#number
#result
#working
#trying
#preview
#image
#comments