.

DOLLAR Function Dictionary

Function Dictionary Function Examples Function Categories

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.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download