I need some help.
I figure this is a fairly common question, but I cant find what Im needing, through google search or through this forums search. I made a chart where there is a column for each day. I have the following formula in B73
=B71/B72
By default I'd like all three cells to show $0 until information is entered. But since B71 and B72 have $0, B73 comes up as #DIV/0!
How do I fix this?
Use:
Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Awesome! It worked great and did exactly what I was hoping for. Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks