Forum Discussion
Liz_VC
Nov 07, 2022Copper Contributor
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...
- 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.", "")
Harun24HR
Nov 07, 2022Bronze Contributor
Welcome! If this help, then please consider mark this answer as best response (tick mark the answer). It means your problem is solved.
- Liz_VCNov 07, 2022Copper ContributorDid I wait too long to tick mark the answer? I don't see the option.
- HansVogelaarNov 07, 2022MVP