May 21, 201213 yr Is there a way to enter percentages without the decimal in front? IE; when a formula contains a percentage, say 10%, is there a way I can just punch in 10 rather than .10 and get the correct answer? Thanks in advance, Charlie
May 21, 201213 yr I use this then they can enter it either way Case(TotalDiscountTaken > 1 ; TotalDiscountTaken / 100 ; TotalDiscountTaken)
Create an account or sign in to comment