• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. F

    Applying IFERROR [SOLVED]

    Sara - you're beautiful!! Thank you, thank you! Fendtasia
  2. F

    Applying IFERROR [SOLVED]

    Now that I have corrected my spreadsheet according to the quick answer I received last month, I've found that when the average is not a whole number, the color scheme doesn't work. ie. if the average is 2, color of cell is green, 3 is yellow, 4 is orange, and 5 is red. So I need to be sure the...
  3. F

    Applying IFERROR [SOLVED]

    Wonderful! Thank you, Narayan. My boss will be very happy! Fendtasia
  4. F

    Applying IFERROR [SOLVED]

    Thank you for the tips posted above. However, I guess I'm not as adept at Excel as I thought! I have Excel 2010 and have copied the link below to my worksheet in Drop Box. If there are any questions after reviewing my spreadsheet, please feel free to ask. My objective is to not have the #DIV/0...
  5. F

    Applying IFERROR [SOLVED]

    I don't want the #DIV/0! to show up in my total columns. Here is the situation: There are 6 sections of columns, with 4 columns in each section. For this example, say the 4 columns are A, B, C & D. Each of these is used to rate (from 1 to 5) a different aspect of a unit on 6 (sections) different...
Back
Top