Example of #CALC! Error

%3CLINGO-SUB%20id%3D%22lingo-sub-3124325%22%20slang%3D%22en-US%22%3EExample%20of%20%23CALC!%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3124325%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CBR%20%2F%3EThe%20case%20I%20came%20across%20is%20that%20the%20description%20of%20the%20support.microsoft%20mentions%20that%2C%20for%20example%2C%20the%20formula%20%3DOFFSET%20(A1%2C0%2C0%2C%20%7B2%2C3%7D)%20gives%20a%20%23CALC!%20error%2C%20but%20in%20practice%20gives%20a%20%23VALUE!%20error.%20Please%20help%20in%20this%20regard.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SHAYAN1350_0-1644237196407.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345817i843F946050D93313%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SHAYAN1350_0-1644237196407.png%22%20alt%3D%22SHAYAN1350_0-1644237196407.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3124325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello
The case I came across is that the description of the support.microsoft mentions that, for example, the formula =OFFSET (A1,0,0, {2,3}) gives a #CALC! error, but in practice gives a #VALUE! error. Please help in this regard.

SHAYAN1350_0-1644237196407.png

 

0 Replies