Hi
Can anyone help with a small formula
I have : Round(column1_*0.75,0)
which gives me 3/4 of the number in column1.
What i need is 3/4 of the number upto a max of 20 and any number over 20 just to treat it as 20
hope that makes sense
jab4279
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.