Forum Discussion

TheFireman408's avatar
TheFireman408
Copper Contributor
May 19, 2021
Solved

Help with (if or) formula in Excel with 3 options (read below)

The Excel cell will have 3 possible results...... "BLUE", "RED", or if it is left Blank/empty.   When BLUE is used, multiply by 2.    When RED is used, just return 1 (i.e. no math function, just u...
  • HansVogelaar's avatar
    HansVogelaar
    May 19, 2021

    TheFireman408 

     

    =IF(A1="","",IF(A1="RED",1,IF(A1="BLUE",2*B1,"?")))

     

    If you have Excel 2019 or Excel in Microsoft 365, you can also use

     

    =IFS(A1="",""A1="RED",1,A1="BLUE",2*B1,TRUE,"?")

Resources