Patty,

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

=SUM(B2:D2)*400

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

=SUM((4-B2:D2)*400)

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

HTH,
Bernie
MS Excel MVP


"Patty Grimm" <Patty wrote in message
...
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?