Nov 06 2022 07:28 PM
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_true" part of an IF formula. This data will be merged with a Word document. This is my formula so far...
=if(D1="Applicable", "and
restricted common shares of Company Ltd. (as traded on the New York Stock Exchange under the symbol CPY, the “Company Stock”), calculated by dividing $ by the Volume Weighted Average Price of the Company Stock, payable at closing.", "")
Here is what I am trying to accomplish:
=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 for any suggestions.
Liz
Nov 06 2022 08:38 PM
Solution@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.", "")
Nov 06 2022 08:59 PM
Nov 07 2022 12:14 AM
Nov 07 2022 10:41 AM
Nov 07 2022 10:43 AM
Nov 07 2022 12:22 PM
I already marked @Harun24HR 's reply as the answer.
Nov 07 2022 12:26 PM
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.", "")
Nov 06 2022 08:38 PM
Solution@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.", "")