Home

Excel cell error

%3CLINGO-SUB%20id%3D%22lingo-sub-719990%22%20slang%3D%22en-US%22%3EExcel%20cell%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719990%22%20slang%3D%22en-US%22%3EI%20have%20a%20row%20of%20cells%20containing%20numbers%20when%20filled%20in.%20Cells%202%20and%203%20are%20added%20together%20to%20produce%20a%20sum%20in%20the%204th%20cell%2C%20which%20works%20fine%20with%20no%20errors%2C%20but%20when%20I%20add%20a%20number%20to%20the%201st%20cell%20(not%20related%20to%20the%20sum)%20the%204th%20cell%20shows%20an%20error%20as%20it%20thinks%20it's%20part%20of%20the%20formula.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20question%20is%2C%20is%20there%20a%20way%20to%20trick%20the%20formula%20in%20not%20looking%20at%20the%201st%20cell%20to%20stop%20the%20error%20coming%20up%20through%20out%20the%20sheet%3F%20I%20can%20add%20a%20separate%20column%20between%20cells%201%20and%202%20and%20hide%20it%20but%20dont%20want%20to%20have%20to%20do%20this%20as%20it%20looks%20messy.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20help%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-719990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-720131%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366456%22%20target%3D%22_blank%22%3E%40Carlos2750%3C%2FA%3E%26nbsp%3B%2C%20it%20looks%20like%20duplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-cell-error%2Fm-p%2F720096%2Fhighlight%2Ffalse%23M33499%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-cell-error%2Fm-p%2F720096%2Fhighlight%2Ffalse%23M33499%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Carlos2750
Occasional Contributor
I have a row of cells containing numbers when filled in. Cells 2 and 3 are added together to produce a sum in the 4th cell, which works fine with no errors, but when I add a number to the 1st cell (not related to the sum) the 4th cell shows an error as it thinks it's part of the formula.

My question is, is there a way to trick the formula in not looking at the 1st cell to stop the error coming up through out the sheet? I can add a separate column between cells 1 and 2 and hide it but dont want to have to do this as it looks messy.

Can anyone help?
1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies