NEED HELP EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-2130568%22%20slang%3D%22en-US%22%3ENEED%20HELP%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2130568%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20anyone%20help%20on%20what%20is%20wrong%20with%20my%20formula%20because%20it%20does%20not%20generate%20the%20return%20value..%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%22Javsite_2579_0-1613181461039.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254668i190B6E526511FE76%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Javsite_2579_0-1613181461039.png%22%20alt%3D%22Javsite_2579_0-1613181461039.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-2130568%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2130597%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2130597%22%20slang%3D%22en-US%22%3EThe%20formulas%20look%20fine%20on%20the%20surface.%20What%20DO%20the%20formulas%20(they%20are%20different)%20generate%3F%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20attach%20that%20in%20the%20form%20of%20a%20spreadsheet%2C%20not%20just%20the%20image%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2130718%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2130718%22%20slang%3D%22en-US%22%3Ehi%2C%3CBR%20%2F%3Ethanks%20for%20reaching%20out.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20the%20formula%20was%20recognized%20as%20text%20inside%20the%20cell%20and%20not%20as%20function.%3C%2FLINGO-BODY%3E
New Contributor

Hi community,

 

can anyone help on what is wrong with my formula because it does not generate the return value..

 

Javsite_2579_0-1613181461039.png

 

5 Replies
The formulas look fine on the surface. What DO the formulas (they are different) generate?

Can you attach that in the form of a spreadsheet, not just the image?
hi,
thanks for reaching out.

I think the formula was recognized as text inside the cell and not as function.

@Javsite_2579that was my working hypothesis. Glad you got it resolved.

here is the link of my source file. https://1drv.ms/x/s!AjOpel9Zjt_8iHBZkLk9Aqgt6P-p?e=GzfVIe

@Javsite_2579 

 

I think you've resolved it, right? No need to look at the file.

 

And for future reference, it's generally better to just drag and drop the file to the area below, when you're posting a message. Not to put a link to an outside server.