Forum Discussion
Solved
Insert the numerical content of a cell in text that is part of an IF formula
Hello: I hope you guys can help me with a formula. I am a newbie so please be kind. Here goes... I need to insert the numerical content of several different cells into text that is the "value_if_tr...
Liz_VC You may try-
=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.", "")
One more thing to add, please....
How can I make the number in $ " & P2 &" retain its Accounting format?
How can I make the number in $ " & P2 &" retain its Accounting format?
To use accounting format for the value of P2:
=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 " & TEXT(P2, "_-$* #,##0.00_-;-$* #,##0.00_-;_-$* ""-""??_-;_-@_-") &" by the Volume Weighted Average Price of the Company Stock, payable at closing.", "")