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
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
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
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
Re: Percentages
Your second formula worked.
Thanks
Eddie
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.
Don’t have an account yet? Register yourself now and be a part of our community!