Web Applications Asked by user264021 on February 15, 2021
I’m trying to nest the following IF statements. In order to have a different word returned according to what word is in the other cell.
=(IF((D2 = "Your Spouse / Partner"), "my partner", “x”)), (IF((D2 = "Your Friend"), "my friend”, "x"))
It’s not working but individually the formulas do work.
Removing the extra parenthesis and putting the second IF as the third argument of the first:
=IF(D2 = "Your Spouse / Partner", "my partner", IF(D2 = "Your Friend", "my friend”, "x"))
Answered by Rubén on February 15, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP