aaronmberg
New Member
- Joined
- Feb 2, 2006
- Messages
- 10
Here is part of an If statement that I am using.
=IF(AND(B45<0,B45<(E45+F45)),"BUY"&" "&ROUND(ABS($B45-(E45+$F45)),0)
If this is true and it returns "BUY ####", how can I format the number to have a comma separating thousands (#,###)?
Thanks in advance!
=IF(AND(B45<0,B45<(E45+F45)),"BUY"&" "&ROUND(ABS($B45-(E45+$F45)),0)
If this is true and it returns "BUY ####", how can I format the number to have a comma separating thousands (#,###)?
Thanks in advance!