Formulas advanced

[Patty Grimm]

I am creating a worksheet and would like to use letters or specific numbers
(such as X=1,200 or 1=1,200. 2=800 and 3=400) to represent values.

Mentor: Sally Sue 1 2 3 formula to
reflect total amount

Does anyone know how do to this?

 

[Bernie Deitrick]

Patty,

If you used 3 = 1200, 2 = 800, and 1 = 400, you could use

=SUM(B22)*400

If you still want 1 = 1200 etc, then array enter (enter using Ctrl-Shift-Enter)

=SUM((4-B22)*400)

If your values aren't so well organized, then you would need a different formula.

HTH,
Bernie
MS Excel MVP

 

[FSt1]

hi
your example is a tad confusing but maybe this will give you ideas...
=if(c1=1,200,if(c1=2,800,if(c1=3,400,0)))

if you want the cell to display nothing, replay the last zero with "".
you can have up to 7 if's in 2003. 16 in 2007(i'm told)

Regards
FSt1