create an UDF for max T1

[btamsgn]

I want to create a user vba function according to the following rules:
Rule: 45-25-10-15 (cell B1: E1)
Where: T1 = 45, T2 = B1 + C1, T3 = C1 + D1, T4 = D1 + E1
T1 gradually increases until T4 <= 100
If T4 <= 100, stop and return about the big value get from T1
Cell G1=max T1
Refer to the attached file
Looking Forwarding to receiving from responses, thanks.

 

[arnelgp]

do you need the listing.
here is a function without the listing.

 

[btamsgn]

do you need the listing.
here is a function without the listing.

Thank you very much.
You are excellent.

 

[Pat Hartman]

This is Access, not Excel. Access doesn't have cells. Please explain the formula using words so we can make sense of it.

Windows says the zip file is empty.

 

[btamsgn]

This is Access, not Excel. Access doesn't have cells. Please explain the formula using words so we can make sense of it.

Windows says the zip file is empty.

I used excel to express my idea after that I use the function to apply in my file accdb

 

[Pat Hartman]

Well, if arnelgp guessed right, you have an answer.

 

[Mike Krailo]

Windows says the zip file is empty.

7zip would not open it either, I had to use WinRar and then it extracted OK. Here is a view of the excel file so others can see what your talking about.

 

[Pat Hartman]

I guess arnel now has a job as your programmer

 

[Pat Hartman]

You've already got one programmer working for you. You don't need others to compete.

 

[Gasman]

I guess arnel now has a job as your programmer

arnelgp has them queuing up on this site.
https://www.access-programmers.co.uk/forums/threads/query-or-function-to-rank.319832/