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.
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.