Hallo,
I would like to offer readers the opportunity to solve the following formula with input (number fields):
This is my equation:
1,15 · (M – (a + b · M + c · Y) ·Y) Euro
values for a, b, c:
if fieldname1 = 1 -> a = 0,04, b = 0,0004991, c = 0,00004620
if fieldname1 = 2 -> a = 0,03, b = 0,0003716, c = 0,00003450
if fieldname1= 3 -> a = 0,02, b = 0,0003716, c = 0,00002780
if fieldname1 = 4 -> a = 0,01, b = 0,0003035, c = 0,00002000
if fieldname1 = 5 -> a = 0,00, b = 0,0002251, c = 0,00001950
…
values for M and Y:
M = rent = fieldname3 (200 – 2500 €)
Y = monthly income = fieldname 4 (700-4000 €)
number of people = fieldname1 (1 – 5 people)
level = fieldname2 (7 levels)
rent = fieldname3 (200 – 2500 €) = M
M must be limited if the number of people and the rent (in different regions – fieldname2) exceed certain values – otherwise fieldname3 can be adopted:
if fieldname1 = 1
and fieldname2 = 1 and fieldname3 >= 347 take 347
and fieldname1 = 2 and fieldname3 >= 392 take 392
and fieldname2= 3 and fieldname3 >= 438 take 438
4
5
6
7
if fieldname1 = 2
and fieldname2= 1 and fieldname3 >= 420 take 420
and fieldname2= 2 and fieldname3 >= 474 take 474
3
4
5
6
7
if fieldname1= 3
and fieldname2= 1 and fieldname3 >= 501 take 501
and fieldname2= 2 and fieldname3 >= 564 take 564
3
4
5
6
7
fieldname1= 4
…
else if fieldname3 < if-statements above (347, 392, 438, 420, 474, …) take fieldname3
Is there a way to do this?
Thanks for help!
Soenke
The page I need help with: [log in to see the link]