Discover and read the best of Twitter Threads about #excelsheets

Most recents (1)

Benjamin Franklin once said, "in this world, nothing can be said to be certain, except death and taxes". ๐Ÿ˜Ž
Short ๐Ÿงต#spreadsheets #excelsheets
Here is a LAMBDA function that calculates PAYE #taxes in #Kenya using current brackets
#excelspreadsheet
=LAMBDA(salo,
LET(maxAmt, 32333.33,
minAmt, 24000,
minT,2400,
midT, 2083.33,
SWITCH(TRUE,
salo>maxAmt, ((salo-maxAmt)*0.3)+minT+midT,
salo>minAmt, ((maxAmt-salo)*0.25)+minT,
salo=minAmt,minT,
TRUE, 0)
)
)
#Excel
Read 3 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!