B
Barbara Bell
How do you set a validation for percentage amounts. I
want to set up an interest rate less than 8.01%
want to set up an interest rate less than 8.01%
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
J.E. McGimpsey
Try:
Allow: Decimal
Data: Between
Minimum: 0
Maximum: 0.0801
Allow: Decimal
Data: Between
Minimum: 0
Maximum: 0.0801
B
Barbara Bell
I have tried that, it keeps giving me an input error when
I type in 8..I think it has something to do with my number
format but I don't know
I type in 8..I think it has something to do with my number
format but I don't know
J
J.E. McGimpsey
8% = 0.08 so if you want to enter percentages, you'll have to either
enter "8%" (without quotes) or "0.08" (without quotes).
If you want to enter an integer instead, set up validation for a
maximum of 8 and divide the cell's value by 100 in your follow-on
calculations.
enter "8%" (without quotes) or "0.08" (without quotes).
If you want to enter an integer instead, set up validation for a
maximum of 8 and divide the cell's value by 100 in your follow-on
calculations.
P
Peo Sjoblom
You realize that 8 is 800%
Pre-format cell as percentage or enter it as 0.08
Pre-format cell as percentage or enter it as 0.08
F
friend
use validation, yiou can use less than 8.02 or
less than or equal 8.01
less than or equal 8.01