Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

IF Formulas

Copper Contributor

Can someone help me correct this IF formula? Thanks!

 

=IF(A1="abc","hello", IF(A1="def","goodbye"), "welcome")

 

If A1 = abc then put text hello, if A1 = def put text goodbye, otherwise put welcome.

2 Replies
best response confirmed by NZOIA (Copper Contributor)
Solution
Hi, I think that is: =IF(A1="abc","Hello",IF(A1="def","goodbye","Welcome"))
Awesome, thanks, that has done the trick.
1 best response

Accepted Solutions
best response confirmed by NZOIA (Copper Contributor)
Solution
Hi, I think that is: =IF(A1="abc","Hello",IF(A1="def","goodbye","Welcome"))

View solution in original post