ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   If-Then-Else resulting in DIV/0 error (https://www.excelbanter.com/excel-programming/313067-if-then-else-resulting-div-0-error.html)

scapen[_3_]

If-Then-Else resulting in DIV/0 error
 

Well, my questions is why am I still receiving the div/o error? It'
not apparent to me, if you know of a good place to go for examples tha
would be great. I've been battling over this for a while.

thanks - any input/advice is appreciated

--
scape
-----------------------------------------------------------------------
scapen's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26789


Tom Ogilvy

If-Then-Else resulting in DIV/0 error
 
Your mixing code with worksheet functions. It is hard to tell what your
want to do.

if a worksheet function

=if(iserror(something),0,something)

--
Regards,
Tom Ogilvy

"scapen" wrote in message
...

Well, my questions is why am I still receiving the div/o error? It's
not apparent to me, if you know of a good place to go for examples that
would be great. I've been battling over this for a while.

thanks - any input/advice is appreciated.


--
scapen
------------------------------------------------------------------------
scapen's Profile:

http://www.excelforum.com/member.php...o&userid=15156
View this thread: http://www.excelforum.com/showthread...hreadid=267893





All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com