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