Forum Discussion

NZOIA's avatar
NZOIA
Copper Contributor
Jan 28, 2024

IF Formulas

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.

Formulas and Functions
  • samarmesto's avatar
    samarmesto
    Jan 28, 2024
    Hi, I think that is: =IF(A1="abc","Hello",IF(A1="def","goodbye","Welcome"))
  • samarmesto's avatar
    samarmesto
    Copper Contributor
    Jan 28, 2024
    Hi, I think that is: =IF(A1="abc","Hello",IF(A1="def","goodbye","Welcome"))
    • NZOIA's avatar
      NZOIA
      Copper Contributor
      Jan 29, 2024
      Awesome, thanks, that has done the trick.

Resources