|Just out of curiosity...|
Is that your actual formula?
Is "((G35*0.025)*0.18)*0.4" written as it is?
Meaning, is "((G35*0.025)*0.18)*0.4" the actual numbers, or
are they a formula, which you have just replaced with values
for the sake of an example.
(Hope I made myself clear.)
If your formula is correct (as posted by Mike), then I see no
reason why you can't shorten it to:
AND(G35>=7000000, G10>=3500000), AND(G35>=6000000,
G10>=3000000), AND(G35>=5000000, G10>=2500000),
AND(G35>=4000000, G10>=2000000), AND(G35>=3000000,
G10>=1500000)), G35*0.025*0.18*0.4, 0)
It just seems to me that you do the exact same thing every
time, regardless of the different sets of validations.
I have tested both my and Mike's version.
They seem to give the same results.
The formula is all on one line.