Excel Function : DOLLAR

Download now!

Excel Function : DOLLAR

Category

Text

Description

Converts a number to text, using the $ (dollar) currency format

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DOLLAR-function-a6cd05d9-9740-4ad3-a469-8109d18ff611

Syntax and Description of the DOLLAR Excel Function

. =IF(AND(C:C=1,D:D=1),DOLLAR(E:E*F:F*G:G,5),DOLLAR(E:E*F:F,5)) I have the syntax for the IF statement correct. I've been messing with the DOLLAR function for quite some time, and cannot come up with the correct syntax. Thanks for the help. A: Use SUM: =SUM(IF((C:C=1)*(D:D=1),E:E*F:F*G:G,E:E*F

About DOLLAR Excel Function

The DOLLAR function converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,###,##0.00_);($#,###,##0.00)..