LinkBack URL
About LinkBacks
Hello friends,
Herewith i have attached a file. In sheet named "JGU" in cell no. F 14 i want 0 if instead of #DIV/0! when formula does not find any value.
please suggest.
Lokpal Singh
Hello friends,
Herewith i have attached a file. In sheet named "JGU" in cell no. F 14 i want 0 if instead of #DIV/0! when formula does not find any value.
please suggest.
Lokpal Singh
Try
=IFERROR(your_current_formula,0)
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks it is done
Lokpal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks