 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Getting rid of #DIV/0!
This is the formula I'm using =sum(E12*100)/F12. If E12 is left blank with no entry I get #DIV/0!. How can I get rid of that result without having to put a zero in E12? Trap for F12 being blank or a zero. =IF(OR(F12="",F12=0),"",(E12*100)/F12) Gord Dibben MS Excel MVP >This is the formula I'm using =sum(E12*100)/F12. If E12 is left >blank with no entry I get #DIV/0!. How can I get rid of that result >without having to put a zero in E12? Try this formula =IF(ISERROR((E12*100)/F12),"",(E12*100)/F12) What you're saying is IF The Value E12*100 / F12 IS an ERROR then display "" (blank) else work out the sum and display it. Hope this works. > This is the formula I'm using =sum(E12*100)/F12. If E12 is left > blank with no entry I get #DIV/0!. How can I get rid of that result > without having to put a zero in E12?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.