| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell equals, give total of another cell
I have written a formula that looks like this:
=IF(Historical!I10="X","value(Historical!A10)","") The true value returns "Historical!A10" rather than the value showing in the cell. How do I fix this? -- Lori |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If cell equals, give total of another cell
Take the quotation marks out of the true value:
=IF(Historical!I10="X",Historical!A10,"") "Lori Burton" wrote: I have written a formula that looks like this: =IF(Historical!I10="X","value(Historical!A10)","") The true value returns "Historical!A10" rather than the value showing in the cell. How do I fix this? -- Lori |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If cell equals, give total of another cell
argh!!!! The quotes!!!
Thank you! -- Lori "BekkiM" wrote: Take the quotation marks out of the true value: =IF(Historical!I10="X",Historical!A10,"") "Lori Burton" wrote: I have written a formula that looks like this: =IF(Historical!I10="X","value(Historical!A10)","") The true value returns "Historical!A10" rather than the value showing in the cell. How do I fix this? -- 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) | |||
Hybrid Mode
