Forum Discussion

Liz_VC's avatar
Liz_VC
Copper Contributor
Nov 07, 2022
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...
  • Harun24HR's avatar
    Nov 07, 2022

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

Resources