View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alicia from Ft Lauderdale Alicia from Ft Lauderdale is offline
external usenet poster
 
Posts: 1
Default 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"