![]() |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com