Setting a format within an expression (2003 sp3)

Topic

New Reply

I am building an expression =IF(A3>A2,(“Gain of ” & (A3-A2)),”Loss”), and I want to format (A3-A2) as currency, how can I do that?

Reply | Quote

Replies

You can use the TEXT function for this:

=IF(A3>A2,"Gain of "&TEXT(A3-A2,"$#,##0.00"),"Loss")

Reply | Quote

What would I do without my friend from the Netherlands? Works beautifully of course.

Reply | Quote