Make this: &TEXT(Sheet1!A1,"$#,###")&" display 0 instead of blank if value is 0

[CH_AIC]

Hey, y'all! Working on a spreadsheet and need this to display the number in Sheet!A1, but if it's 0, show $0 instead of just "$".

The full context while taking out potentially sensitive info is:
= "(Example Text "&TEXT('Example Page'!J34,"$#,###")&" + Example Text "&TEXT('Example Page'!K34,"$#,###")&"

I tried not using &TEXT and just referencing the cell directly which works for displaying $0 instead of just $, but it removed the thousands separator commas when there are values > 0.


Any guidance is much appreciated!

Kind regards.

[Glenn Kennedy]

Try:

="Example Text $"&IF(A1=0,0,TEXT(A1,"#,###"))

[Fluff13]

Maybe

="Example Text "&TEXT(J34,"$#,##0")&" + Example Text "&TEXT(K34,"$#,##0")

[CH_AIC]

Those work! Thank y'all!

[Fluff13]

Glad to help & thanks for the feedback.