Use Of DOLLAR
Original Number
|
Converted To Text
| |
10
|
₹ 10.00
|
=DOLLAR(C4)
|
10
|
₹ 10
|
=DOLLAR(C5,0)
|
10
|
₹ 10.0
|
=DOLLAR(C6,1)
|
10
|
₹ 10.00
|
=DOLLAR(C7,2)
|
10.25
|
₹ 10.25
|
=DOLLAR(C8)
|
10.25
|
₹ 10
|
=DOLLAR(C9,0)
|
10.25
|
₹ 10.3
|
=DOLLAR(C10,1)
|
10.25
|
₹ 10.25
|
=DOLLAR(C11,2)
|
What Does It Do?
This function converts a number into a piece of text formatted as currency.
Syntax
=DOLLAR(Number,DecimalPlaces)
Number : This is the number which needs to be converted.
DecimalPlaces : This is the amount of decimal places needed in the converted number.
Formatting
No special formatting is needed.
The result will be shown as a text entry.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें