Forum Discussion
Solved
Make cell value keep its Accounting format when placed in the middle of IF formula with text
Hello:
Can you guys help me with this....
How can I make " & P2 &" keep its Accounting format when placed in the middle of IF formula with text? See formula below...
IF(D1="Applicable", "and " & C2 &" restricted common shares of Company Ltd. (as traded on the New York Stock Exchange under the symbol CPY, the “Company Stock”), calculated by dividing $ " & P2 &" by the Volume Weighted Average Price of the Company Stock, payable at closing.", "")
Thanks in advance!
This is the idea:
="Total owed to you: "&DOLLAR(A1)You could also use TEXT which can handle dates if you're in a situation where you're concatenating those:
="Total owed to you: "&TEXT(A1,"$#,##0.00")
3 Replies
This is the idea:
="Total owed to you: "&DOLLAR(A1)You could also use TEXT which can handle dates if you're in a situation where you're concatenating those:
="Total owed to you: "&TEXT(A1,"$#,##0.00")- Thank you Patrick! That worked beautifully.
- You're welcome!
