"," in 1000's place

[Repoort]

So the formula I have is:

=IF(OR(ISBLANK(C18),ISBLANK(E18)),"",(E18-C18)&" "&"Lbs")

The problem is that if the answer were to be 1000 I can not get it to show with the "," in the 1000s place.
I have taken out the &" "&"Lbs" and it works so I know it is the formula. I would like the answer to be displayed as:
1,000 Lbs with the space between the number and the Lbs. Not sure if it is a simple cell format issue or a formula issue. Any help is appreciated. Thanks

 

[sitewolf]

so what you're trying to accomplish works but for getting the Lbs added?
For one, no need to concatenate twice- &" Lbs" would suffice, but not sure that's your issue.

 

[njimack]

=IF(C18*E18,TEXT(E18-C18,"#,##0")&" lbs","")

 

[Repoort]

Njimack it worked like a charm. Thank you

 

[RoryA]

You could also just give the cell a custom number format of
#,##0" lbs"
and then just do the maths in the cell. That way it will also remain an actual number.