Hi All,
Before I start, I would like to say thank for anyone's helps, it will be well appreciated.
I am getting an error #Div/0!. I do understand why I am getting it, because I am diving by 0. However, I placed 0 in the columns as I am waiting for different people to enter their details.
is there away to show to result as 0 instead of #Div/0!.
one way is to wrap in an iferror function
iferror(your formula,0)
Hi,
You could look for the zero in column B like this...
Formula:
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
THANK YOU EVERYONE solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks