I am trying to combine 2 statements and am having difficulties. I'm trying to use an IF statement, but there are more than one factors to produce true or false:
I am calculating 10% of a number and need to set a minimum and maximum level on the 10%. If 10% of the value is less than 8, then equal 8 and IF 10% of the value is greater than 80, then equal 80. Otherwise equal 10% of the value.
Thanks for your help.