The spreadsheet is showing a zero value error when one of the cells in the formula that I am dividing by is 0, I read how to show zero values but I have an IF statement in there already and it is returning a mulitple IF statement error when I try to edit it. I have attached the file and highlighted the cell that I am having problems with. Please Help!
Copy and paste this formula to Cell F24
=IF(F14<1,0,+IFERROR(F14/F5,0))
Try checking the denominator first,
=IF(OR(F5=0,F14<1),0,F14/F5)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yes! Thank you so much. That solved the problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks