Home : DPC
Q14358 - INFO: DPC
DPC returns the number of decimal places for the given value.

SYNTAX:

DPC(Value)

Value:  Value to be evaluated.  Can be numeric value,text, cell reference, or another function.

SEE ALSO: GPREC, GDP, SFRZ, SFR, SFC

EXAMPLES:

Value Formula Result
124.2000 DPC(B3)  4
5.7 DPC(B4)  1
<0.1234 DPC(B5)  4
<0.00100 DPC(B6,3,3,1) 5

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/25/2016 1:16 PM.
Last Modified on 1/25/2016 1:18 PM.
Last Modified by Scott Dorner.
Article has been viewed 1096 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article