Hi,
I have following values.
A1 -100
B1 - either zero or blank
C1 - Formula A1/B1
When B1 is either zero or blank it gives me #DIV/0! value. Is there a way to avoid it.
Thnx
NKRA
Hi,
I have following values.
A1 -100
B1 - either zero or blank
C1 - Formula A1/B1
When B1 is either zero or blank it gives me #DIV/0! value. Is there a way to avoid it.
Thnx
NKRA
Last edited by NKRA; 07-28-2010 at 05:23 PM.
you could use
where it shows nothing if it finds an error. ( the ,"" part).Please Login or Register to view this content.
If you are using a pre 2007 version of excel you might need to code a module so you are able to use that function.
alt+F11 or right click->view code to get into vba editor.
On the upper menu go to Insert-> choose module from drop down list.
copy and paste this
File->Close and return to Microsoft ExcelPlease Login or Register to view this content.
I believe you wanted to iserror, when i used the =iserror(A1/B1,"") formula is not being accepted.
Any other resolution. I want to get C1 as zero if B1 is Blank or Zero.
Cannot use macro or codes.
returns 0 if B1=0 or B1 is blank. returns A1/B1 if any other value.Please Login or Register to view this content.
Or
=IF(SUM(B1),A1/B1,0)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Worked like Charm, Thanks for help
Marked it as Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks