I am trying to automate calculating a value. Using this example;
I have the (13.13%) percentage and the another value (25,000).
The math formula should be .1313 x 25,000 = 3,285.5 (what I am tryin to get).
The issue is that I am getting the percentage like this;
13.13
I cant figure out how to move the decimal two spots to the left so I get
.1313
Can anyone help me out? I can use Formatter or Google Sheets.
Thanks in advance!
Question
How do I automate calculation of values by adjusting decimal places in a percentage using Formatter or Google Sheets?
- Beginner
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.