I need solution for this.

%3CLINGO-SUB%20id%3D%22lingo-sub-2923011%22%20slang%3D%22en-US%22%3EI%20need%20solution%20for%20this.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2923011%22%20slang%3D%22en-US%22%3E%3CP%3Ethe%20file%20is%20attached.%20need%20solution%20for%20task%20in%20sheet%20%22create%20a%20calculator%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2923011%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-2929877%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20solution%20for%20this.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2929877%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205953%22%20target%3D%22_blank%22%3E%40weirdwildwanderer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20365%20with%20Power%20Query.%3C%2FP%3E%3CP%3ECreate%20Calculator%20for%20Hotels%2C%20Cabs%20with%20Tables%20and%20PQ%20Parameters.%3C%2FP%3E%3CP%3ENo%20formulas%2C%20no%20VBA%20macro.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mediafire.com%2Ffile%2F5b94t8xfqvgfmn4%2F11_04_21.xlsx%2Ffile%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mediafire.com%2Ffile%2F5b94t8xfqvgfmn4%2F11_04_21.xlsx%2Ffile%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mediafire.com%2Ffile%2Fq3bj9tvdxt8vf6q%2F11_04_21.pdf%2Ffile%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mediafire.com%2Ffile%2Fq3bj9tvdxt8vf6q%2F11_04_21.pdf%2Ffile%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2930753%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20solution%20for%20this.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205953%22%20target%3D%22_blank%22%3E%40weirdwildwanderer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20if%20you%20have%20concrete%20questions%20we%20may%20help%2C%20but%20not%20to%20do%20the%20task%20(looks%20like%20homework)%20for%20you%20from%20scratch.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

the file is attached. need solution for task in sheet "create a calculator"

2 Replies

@weirdwildwanderer 

Excel 365 with Power Query.

Create Calculator for Hotels, Cabs with Tables and PQ Parameters.

No formulas, no VBA macro.

https://www.mediafire.com/file/5b94t8xfqvgfmn4/11_04_21.xlsx/file

https://www.mediafire.com/file/q3bj9tvdxt8vf6q/11_04_21.pdf/file

 

@weirdwildwanderer 

Sorry, if you have concrete questions we may help, but not to do the task (looks like homework) for you from scratch.