Hi,
i've inherited a spreadsheet that works out an indices. I'm having problems with #DIV/0! and correcting the formula. I've used an IF but to no joy. the formula is
=(((B2-B6)/B6)*100)+100
cells B2 and B6 both have the value 0.0% hence the #DIV/0!
can anyone help please?
Thanks
HI divedeeper,
To avoid error, use below formula:-
Formula:
Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks