173 hàm EXCEL
- 0 / 0
-
(Tài liệu chưa được thẩm định)
Nguồn:
Người gửi: Đoàn Văn Anh (trang riêng)
Ngày gửi: 12h:06' 01-12-2009
Dung lượng: 1.1 MB
Số lượt tải: 95
Nguồn:
Người gửi: Đoàn Văn Anh (trang riêng)
Ngày gửi: 12h:06' 01-12-2009
Dung lượng: 1.1 MB
Số lượt tải: 95
Số lượt thích:
0 người
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.
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.
Các ý kiến mới nhất