Lambda Excel Function Example from Day to Day Life #LAMBDA

%3CLINGO-SUB%20id%3D%22lingo-sub-1965444%22%20slang%3D%22en-US%22%3ELambda%20Excel%20Function%20Example%20from%20Day%20to%20Day%20Life%20%23LAMBDA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1965444%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22css-901oao%20css-16my406%20r-1qd0xha%20r-ad9z0x%20r-bcqeeo%20r-qvutc0%22%3E%3CA%20title%3D%22%23Lambda%20Excel%20Function%20Example%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFPMd2t5m_dc%26amp%3Bfeature%3Dyoutu.be%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20I%20Build%20Custom%20Function%20for%20day%20to%20day%20task%3C%2FA%3E%26nbsp%3BHey!%20This%20is%20too%20good.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22css-901oao%20css-16my406%20r-1qd0xha%20r-ad9z0x%20r-bcqeeo%20r-qvutc0%22%3EI%20just%20tried%20on%20my%20tasks%20i.e.%20TDS%20Calculation%20and%20I%20used%20to%20depend%20on%20the%20software%20because%20the%20hard%20coded%20value%20is%20safer%20than%20input%20in%20Excel%20by%20someone%20and%20here%20I%20have%20created%20custom%20function%20for%20this%20activity%20do%20this.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22css-901oao%20css-16my406%20r-1qd0xha%20r-ad9z0x%20r-bcqeeo%20r-qvutc0%22%3E%26nbsp%3BTake%20an%20example%20like%20this%20few%20category%20TDS%20Percentage%20and%20there%20are%20many%20others%20which%20needs%20to%20be%20keep%20in%20mind%20while%20working%20and%20everyone%20have%20to%20refer%20percentages%20or%20depend%20on%20the%20softwares%20for%20calculcation.%20No%20more%20I%20have%20created%20customer%20functions%20for%20these%205%20and%20I%20am%20going%20to%20build%20for%20all%20the%20categories.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22280%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22203%22%3ETDS%20Category%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2277%22%3EPercentage%3C%2FTD%3E%3CTD%3EAccumulated%20PF%3C%2FTD%3E%3CTD%3E10%25%3C%2FTD%3E%3CTD%3EInterest%20Received%20on%20Securities%3C%2FTD%3E%3CTD%3E7.50%25%3C%2FTD%3E%3CTD%3ELottery%3C%2FTD%3E%3CTD%3E30%25%3C%2FTD%3E%3CTD%3EInsurance%20Comission%3C%2FTD%3E%3CTD%3E3.75%25%3C%2FTD%3E%3CTD%3ECash%20Withdrawl%3C%2FTD%3E%3CTD%3E2%25%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERef%20How%20I%20did%20this.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFPMd2t5m_dc%26amp%3Bfeature%3Dyoutu.be%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFPMd2t5m_dc%26amp%3Bfeature%3Dyoutu.be%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELoved%20this%20feature.%20Will%20be%20doing%20many%20more%20things%3C%2FP%3E%3CDIV%20class%3D%22css-1dbjc4n%20r-xoduu5%20r-1mlwlqe%20r-1d2f490%20r-1udh08x%20r-u8s1d%20r-h9hxbl%20r-417010%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22css-901oao%20css-16my406%20r-1qd0xha%20r-ad9z0x%20r-bcqeeo%20r-qvutc0%22%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22css-1dbjc4n%20r-xoduu5%20r-1mlwlqe%20r-1d2f490%20r-1udh08x%20r-u8s1d%20r-h9hxbl%20r-417010%22%3E%3CDIV%20class%3D%22css-1dbjc4n%20r-1niwhzg%20r-vvn4in%20r-u6sd8q%20r-x3cy2q%20r-1p0dtai%20r-xoduu5%20r-1pi2tsx%20r-1d2f490%20r-u8s1d%20r-zchlnj%20r-ipm5af%20r-13qz1uu%20r-1wyyakw%22%3E%26nbsp%3B%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1965444%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

How I Build Custom Function for day to day task Hey! This is too good.

 

I just tried on my tasks i.e. TDS Calculation and I used to depend on the software because the hard coded value is safer than input in Excel by someone and here I have created custom function for this activity do this.

 Take an example like this few category TDS Percentage and there are many others which needs to be keep in mind while working and everyone have to refer percentages or depend on the softwares for calculcation. No more I have created customer functions for these 5 and I am going to build for all the categories. 

 

TDS Category PercentageAccumulated PF10%Interest Received on Securities7.50%Lottery30%Insurance Comission3.75%Cash Withdrawl2%

 

Ref How I did this. https://www.youtube.com/watch?v=FPMd2t5m_dc&feature=youtu.be

 

Loved this feature. Will be doing many more things

 

.

 

 

Microsoft has introduced Excel Lambda Function. Lambda new Excel Feature which I think will be the game changer. I will show How you can use Lambda Excel New...
0 Replies