I have some formulas set up in a spreadsheet, and one of the columns is simply column g (for that row) divided by column d (for that row). In some cases, g and d are both 0 which results in #DIV/0! Is there anything that I can add to my simple g1/d1 formula that would return a difference cell's value instead if the result was #DIV/0! ?
=IF(ISERROR(G1/D1),cell_you_want_to_reference,G1/D1)
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".
Use this formula to hide error
=IFERROR(G1/D1,0)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
=if(D1=0,"return a difference cell's value",G1/D1)
Hi there,
You could try:
=IFERROR(G1/D1,[whatever you want returned instead of #DIV/0])
HTH,
FR
Have used several of these, thanks!
You're welcome and thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks