| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't edit cell
I'm trying to just add a simple formula to a cell in Excel
"=sum(A1,I1)" but unfortunately it seems to keep coming back with an error: "Cell contains a Formula. Cannot Modify. Must Select Cancel." I tried searching for this error but I came up empty. Anyone have any ideas on what I am doing wrong? Thank you, Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't edit cell
=A1+I1
"DRLski" wrote: I'm trying to just add a simple formula to a cell in Excel "=sum(A1,I1)" but unfortunately it seems to keep coming back with an error: "Cell contains a Formula. Cannot Modify. Must Select Cancel." I tried searching for this error but I came up empty. Anyone have any ideas on what I am doing wrong? Thank you, Dave |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't edit cell
That sounds like there's a validation
Try going to Data-Validation while you are in the cell. Should show Any Value in the top box. "DRLski" wrote: I'm trying to just add a simple formula to a cell in Excel "=sum(A1,I1)" but unfortunately it seems to keep coming back with an error: "Cell contains a Formula. Cannot Modify. Must Select Cancel." I tried searching for this error but I came up empty. Anyone have any ideas on what I am doing wrong? Thank you, Dave |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't edit cell
I haven;t mastered the art of reading yet. Thank you for giving the right
answer... :-/ "Teethless mama" wrote: =A1+I1 "DRLski" wrote: I'm trying to just add a simple formula to a cell in Excel "=sum(A1,I1)" but unfortunately it seems to keep coming back with an error: "Cell contains a Formula. Cannot Modify. Must Select Cancel." I tried searching for this error but I came up empty. Anyone have any ideas on what I am doing wrong? Thank you, Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| insert date | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
Linear Mode
