anniesolomon
Technical User
I'm using the following expression in an Excel spreadsheet:
=IF(E3+F3>N3,"Good Stock Level","Order "& INT(N3-E3-F3)& " "& D3)
False results return the number without a comma which I would like to have:
"Order 1868 BK" instead of "Order 1,868 BK"
Can anyone tell me how to force the 1000 separator in my expression?
Thanks very much!
Ann
=IF(E3+F3>N3,"Good Stock Level","Order "& INT(N3-E3-F3)& " "& D3)
False results return the number without a comma which I would like to have:
"Order 1868 BK" instead of "Order 1,868 BK"
Can anyone tell me how to force the 1000 separator in my expression?
Thanks very much!
Ann