How to port/convert a formula that works in Excel (office) 365 but not in Excel 2019

[pyclen]

I recently changed jobs and at my old place we had Office365 which was great as I personally have that and for all the work I did I could seamlessly transfer it.
I also have received a tremendous amount of help from members of this board and I hope I will again receive help.

In a previous post I asked (and received the answer, see here: value calculation)

as to when a discount to a rate can be applied. Snakehips provided a great working answer however the formula will not work as I have now this in B19, D19 etc.

=IF(B$15="",0,_xlfn.LET(_xlpm.FT,ROUNDUP(B$15/8,),(MIN(_xlpm.FT,$B$8)*$B$5)+(MAX(0,_xlpm.FT-$B$8))*$B$6))

The problem is that Excel 2019 does not support the FT and LET functions so I need an alternative. If needed I can provide the XL file however I thought the provided info may be enough.

Thank you for any help or idea provided

 

[Fluff]

You can use the same formula, but with LET like

=IF(D12="",0,(MIN(ROUNDUP(D12/$D$3,),2)*$D$6)+(MAX(0,ROUNDUP(D12/$D$3,)-2))*$E$6)

Also as you are now using 2019 I would suggest you update your profile.

 

[dave3009]

FT is a named variable in the LET function. Simply replace any instances of FT with it's set value/formula.

=IF(B$15="",0,(MIN(ROUNDUP(B$15/8,),$B$8)*$B$5)+(MAX(0,ROUNDUP(B$15/8,)-$B$8))*$B$6)

 

[pyclen]

Thank you very much for the quick response
And yes, I guess I need to update the profile although I still have 365 ( just at home)

 

[Fluff]

Glad we could help & thanks for the feedback.

I guess I need to update the profile although I still have 365 ( just at home)

If you need something for 365 then you could always say that in your post. Or leave your profile as 365 & state that something needs to work in 2019.