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)..