Hello everybody
I entered this if function in a form in a Text Box, I put it in data , control source.
this is the if function:
=IIf([Text93]=0,0,
IIf([Text93]=1,2,
IIf([Text93]=2,5,
IIf([Text93]=3,7,
IIf([Text93]=4,10,
IIf([Text93]=5,12,
IIf([Text93]=6,15,
IIf([Text93]=7,17,
IIf([Text93]=8,20,
IIf([Text93]=9,22,
IIf([Text93]=10,25,
IIf([Text93]=11,27,
IIf([Text93]=12,30,
IIf([Text93]=13,32,
IIf([Text93]=14,35,
IIf([Text93]=15,37,
IIf([Text93]=16,40,
IIf([Text93]=17,42,
IIf([Text93]=18,45,
IIf([Text93]=19,47,
IIf([Text93]=20,50,
IIf([Text93]=21,52,
IIf([Text93]=22,55,
IIf([Text93]=23,57,
IIf([Text93]=24,60,
IIf([Text93]=25,62,
IIf([Text93]=26,65,
IIf([Text93]=27,67,
IIf([Text93]=28,70,
IIf([Text93]=29,72,
IIf([Text93]=30,75)))))))))))
this function did not work, an error message say (The expression you entered is too complex.)
are there a solution for that or how to make that function shorter?
thank you