Nov 07 2022 11:41 AM
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!
Nov 07 2022 11:49 AM
SolutionThis 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")
Nov 07 2022 12:40 PM
Nov 07 2022 12:53 PM
Nov 07 2022 11:49 AM
SolutionThis 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")