Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    get rid of #DIV/0! (excel xp)

    I am creating a financial statement of operations. I have columns in it which show a variances. one variance is in whole number and the next is in percent. The column for percent yields a "#DIV/0!" due to the 2004 amount has a zero in it.

    How do I replace the "#DIV/0!" with either a "0" or a "-".

    I am attaching a sample of the report.

    As always, Many thanks to my fellow loungers.

    Marty

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: get rid of #DIV/0! (excel xp)

    Example for L13:

    =IF(H13=0,0,K13/H13*100)

    or

    =IF(H13=0,"-",K13/H13*100)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •