| 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" |
| 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 | |||
Threaded Mode
