| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell equals, give total of another cell
I have a formula that looks likes this:
=IF(Historical!I10="X","Historical!A10","") If true, it returns "Historical!A10" How do I write this formula to give me the value of A10 and not the name of the cell? -- Lori |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If cell equals, give total of another cell
=IF(Historical!I10="X",Historical!A10,"")
Vaya con Dios, Chuck, CABGx3 "Lori Burton" wrote: I have a formula that looks likes this: =IF(Historical!I10="X","Historical!A10","") If true, it returns "Historical!A10" How do I write this formula to give me the value of A10 and not the name of the cell? -- Lori |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel total up the same cell reference across several workshee | Excel Worksheet Functions | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
