Is it possible to display a character, but utilize a value in the same cell?

Giganews Newsgroups
Subject: Is it possible to display a character, but utilize a value in the same cell?
Posted by:  G.T.W (rampa…@easynews.com)
Date: Sat, 25 Oct 2003

I am working on a schedule of inspections.
I have a column that displays either a Q(Quarterly), S(Semi-Annual) or
A(Annual) .  I'd like to be able to link the column to an equation
with the values 4, 2, or 1.  (IE Quarterly is 4 inspections a year)
Can a "Q" be displayed in a cell, but use a math value of 4 as part of
an equation for further calculations
For Example:

Cell A  I Cell B I  Cell C  I  Cell D
  Qty  I  Insp  I  Hours  I  Total
  2          Q          .75

(2 x 4 x .75) = 6 inspection hours Annually

I'd like the sheet to display the type of inspection, for clarity, but
also want that cell to function as part of the equation.  Is this
possible?  Thank you.

Replies