Percentages

eddie57 · Apr 26th 2005

I have a file that has a percentage formula. since i dont have any numbers in the some the cells i am getting ### in the formula cell. How can I have excel not display anything there?

thanks
Eddie

Brandtrock · Apr 26th 2005

Re: Percentages

One way would be:

=IF(ISBLANK(insert a cell address used in your percentage formula here),"",insert your percentage formula itself here)

HTH

eddie57 · Apr 26th 2005

Re: Percentages

This is what i entered:

=IF(ISBLANK(C3),"",B3/C3)

I am not getting the ###, but I am getting "#DIV/0!". Did I do something wrong?

Thanks
Eddie

JF · Apr 26th 2005

Re: Percentages

Looks correct, can you post a sample of your data.

However, if c3 contains a formula or referance to another cell (say c1) and C1 is blank, you get the error becasue at that point the c3 is not blank but actually evaluates to a 0.

you could try:

Code

=if(c3=0,"",b3/c3)

eddie57 · Apr 26th 2005

Re: Percentages

Your second formula worked.

Thanks
Eddie

Anonymous · Apr 26th 2005

Re: Percentages

You also might try:

=IF(or(ISBLANK(C3),ISBLANK(B3)),"",B3/C3)

or

=IF(ISERROR(B3/C3),"",B3/C3)

or

=IF(OR(ISERROR(B3/C3),ISBLANK(B3)),"",B3/C3)

or expand on these. If C3 is blank you will get a Divide by zero error. If B3 only is blank you will get zero. Will thy always both be blank or filled. That is, do you need to make multiple logic checks for all permeatations?

BTW: Your original ### may simply have been a column that was too narrow to display the formula results.

Percentages

Participate now!

Share