173 Hàm trong Excel
Chia sẻ bởi Nguyễn văn quý |
Ngày 14/10/2018 |
57
Chia sẻ tài liệu: 173 Hàm trong Excel thuộc Tư liệu tham khảo
Nội dung tài liệu:
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.
* Một số tài liệu cũ có thể bị lỗi font khi hiển thị do dùng bộ mã không phải Unikey ...
Người chia sẻ: Nguyễn văn quý
Dung lượng: 216,15KB|
Lượt tài: 0
Loại file: rar
Nguồn : Chưa rõ
(Tài liệu chưa được thẩm định)