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.", "")
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.", "")
- Welcome! If this help, then please consider mark this answer as best response (tick mark the answer). It means your problem is solved.
- Did I wait too long to tick mark the answer? I don't see the option.
