SOLVED

Make cell value keep its Accounting format when placed in the middle of IF formula with text

Copper Contributor

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!

 

3 Replies
best response confirmed by Liz_VC (Copper Contributor)
Solution

@Liz_VC 

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.
1 best response

Accepted Solutions
best response confirmed by Liz_VC (Copper Contributor)
Solution

@Liz_VC 

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")

 

View solution in original post