Excel formula to monday.com formula

Platform discussions
1

Hi Team,

Wondering if its at all possible to convert the below excel formula to use in monday.com?

=LET(q,{0;2000;9000;15000},d,{101;-16;-10;-5},SUM((A1>q)*(A1-q)*d))

The formula is to calculate tiered pricing from a single value in one cell. For a couple of reasons, it’s not possible to have the values elsewhere.

I.e.
Price Per Application
0-2000 - $101
2001 - 9000 - $85
9001 - 15000 - $75
15000 - 7000000000- $70

So for 8123 applicants, I know I should have a $ value of $722,455

I know in excel this works exactly the way I need, but not sure it can be adapted to suit monday.com

Cheers!

2

Hello @ScottMartin88 !

Try this!

IF({Applicants}>0,IF({Applicants}<2001,{Applicants}*101,IF({Applicants}<9001,2000*101+({Applicants}-2000)*85,IF({Applicants}<15001,2000*101+7000*85+({Applicants}-9000)*75,IF({Applicants}>15000,2000*101+7000*85+6000*75+({Applicants}-15000)*70)))))

image

Best,
Giannis, Implementation Consultant at thespelas.com

1 Like
3

@GiannisKoukounas - thank you so much! This works perfectly.

Saved me from a nervous breakdown haha

1 Like