Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: If statement - formula not compiling

    I can’t seem to work out the formula for calculating a ratio using the data in the pivot table.

    I’ve added a column next to the pivot table to work out the ratio between to columns.

    =SUM(B11/C11)

    But what if there is no data in cell (B11), I want to return a “ “ (blank space)… but it returns a #DIV/0!

    Can anyone help… attached is the excel worksheet im working on
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2007
    Posts
    37

    Try this

    = If(and(b11<>"",c11<>""),(b11/ C11),"")
    Meyyappan

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    I confused. Wouldn't #Div/0 error indicate that C11 is zero?
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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