173 hàm Excel
- 0 / 0
-
(Tài liệu chưa được thẩm định)
Nguồn: Sưu tầm
Người gửi: Xuân Phú
Ngày gửi: 00h:09' 02-09-2009
Dung lượng: 1.1 MB
Số lượt tải: 147
Nguồn: Sưu tầm
Người gửi: Xuân Phú
Ngày gửi: 00h:09' 02-09-2009
Dung lượng: 1.1 MB
Số lượt tải: 147
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