Question:

Please help me work Excel?

by  |  earlier

0 LIKES UnLike

I barely understand it..but I've got two boxes and applied the qoutient formula..but cant get the answer..just the formula in the box. please please help..im lost!

 Tags:

   Report

3 ANSWERS


  1. Two suggestions:

    Check the format of the cell.  If the cell is formatted as "text" before you type in the formula, then it will disregard the formula and treat it as a text string.  Go to:

    > Format > Cells > if "text" is highlighted, choose General.

    Then, click on the cell, press F2 (to edit it) then press ENTER (to re-confirm it and change it's format).

    Or, check if the sheet is set to display formula's instead of the formula results.  Go to:

    > Tools > Options > checkbox: Formulas (you want it UNchecked).


  2. make sure u put, = , befor u put in the formula

  3. Are you getting an error message? For this particular formula (the quotient formula) if you're getting the #NAME? in the cell it means you need to load the Analysis Tool Pack add-in.

Question Stats

Latest activity: earlier.
This question has 3 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.