Most valuable professional
  • Hot Topics

Excel Excel Formula

Hi, I am a novice to excel. I have provided some mock information below, column A the Grade, B the score, I have calculated the column C using this function =IF(B2:B100>A2:A100,"Exceeding",IF(B2:B100 However, my issue is that I need to display the data in column C on a separate sheet. I cannot have it displayed on this sheet next to column B as the data is extensive in reality and this column will confuse the users. So my question is what formula do I need so that I can generate the column C information in sheet 2. Hope this is clear. Thanks A B C Grade Score 1 3 Exceeding 1 1 At 1 1 At 2 1 Below 2 2 At 1 0 Below

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of June 17, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel