Add the actual value in a cell that contains a formula

[Alicia from Ft Lauderdale]

Hello All... What function would I use to add the actual value in a cell that
contains a formula?

Example given below:

Cell k2 contains =IF(I2=1,"500",IF(I2=2,"1000",IF(I2=3,"1500",0)))
Numerical Value is 500 in this cell

How would I go about adding the values generated? in this case "500"

 

[T. Valko]

Cell k2 contains =IF(I2=1,"500",IF(I2=2,"1000",IF(I2=3,"1500",0)))

Numerical Value is 500 in this cell

No, the value of the cell is a *TEXT* number 500. You probably want to
remove all those quotes:

=IF(I2=1,500,IF(I2=2,1000,IF(I2=3,1500,0)))

Now the cell contains the *NUMERIC* number 500.

Now your addition operation should work.

If that's a "real" formula and the only possible values for I2 are 0 (or
empty), 1, 2 or 3 then this will do the same thing:

=I2*500


--
Biff
Microsoft Excel MVP


"Alicia from Ft Lauderdale" <Alicia from Ft
(e-mail address removed)> wrote in message

 

[Alicia from Ft Lauderdale]

It worked. Thank you.. Thank You... Thank You. Alicia

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Alicia from Ft Lauderdale"