| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add the actual value in a cell that contains a formula
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" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add the actual value in a cell that contains a formula
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 wrote in message ... 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" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add the actual value in a cell that contains a formula
It worked. Thank you.. Thank You... Thank You. Alicia
"T. Valko" wrote: 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 wrote in message ... 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" |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add the actual value in a cell that contains a formula
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Alicia from Ft Lauderdale" m wrote in message ... It worked. Thank you.. Thank You... Thank You. Alicia "T. Valko" wrote: 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 wrote in message ... 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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell contents from formula to the actual result | Excel Discussion (Misc queries) | |||
| Formula results to actual value | Excel Discussion (Misc queries) | |||
| Switching Between Showing Formula Or Actual Result In A Cell ? | New Users to Excel | |||
| what is the 1 minus in this formula actual doing | Excel Worksheet Functions | |||
| formula for month(s) prior to actual | Excel Worksheet Functions | |||
Linear Mode
