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 |
