Goal seek !numb# error in current value

%3CLINGO-SUB%20id%3D%22lingo-sub-3374527%22%20slang%3D%22en-US%22%3EGoal%20seek%20!numb%23%20error%20in%20current%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3374527%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20doing%20goal%20seek%20for%20set%20cell%20X32%2C%20Y32%2C%20Z32%2C%20AA32%2C%20and%20AB32%20to%20value%200%20by%20changing%20infield%20M2%2C%20M3%2C%20M4%2C%20M5%2C%20and%20M6%20respectively%20but%20can't%20find%20any%20current%20value%20every%20time%20!numb%23%20error%20occurs.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Microsoft%20excel%20students%202019.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20sheet%20link%20for%20help.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2F1drv.ms%2Fx%2Fs!AhKtmdj5qSFOlk9IK9I6XdMCD-HF%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2F1drv.ms%2Fx%2Fs!AhKtmdj5qSFOlk9IK9I6XdMCD-HF%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chiukapoor_0-1652522410401.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371648i6BA4360F1C12D1D4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22chiukapoor_0-1652522410401.png%22%20alt%3D%22chiukapoor_0-1652522410401.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-3374527%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am doing goal seek for set cell X32, Y32, Z32, AA32, and AB32 to value 0 by changing infield M2, M3, M4, M5, and M6 respectively but can't find any current value every time !numb# error occurs. 

I am using Microsoft excel students 2019. 

 

Excel sheet link for help.

https://1drv.ms/x/s!AhKtmdj5qSFOlk9IK9I6XdMCD-HF

 

chiukapoor_0-1652522410401.png

 

0 Replies