Forum Discussion

Cathesp's avatar
Cathesp
Occasional Reader
Feb 04, 2026
Solved

Return a value based on different parameters

Not sure if my title is describing my issue correctly.  I have one column where each cell contains the same drop down list from which I can choose one of six options, and depending on what option is ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 04, 2026
    =IF(ISNUMBER(SEARCH("Not Started",F3)),"0%",
IF(ISNUMBER(SEARCH("Started",F3)),"25%",
IF(ISNUMBER(SEARCH("In Progress",F3)),"50%",
IF(ISNUMBER(SEARCH("Nearly There",F3)),"75%",
IF(ISNUMBER(SEARCH("Complete",F3)),"100%","")))))

    This formula works in my sample file.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 04, 2026
=IF(ISNUMBER(SEARCH("Not Started",F3)),"0%",
IF(ISNUMBER(SEARCH("Started",F3)),"25%",
IF(ISNUMBER(SEARCH("In Progress",F3)),"50%",
IF(ISNUMBER(SEARCH("Nearly There",F3)),"75%",
IF(ISNUMBER(SEARCH("Complete",F3)),"100%","")))))

This formula works in my sample file.

 

  • Cathesp's avatar
    Cathesp
    Occasional Reader
    Feb 05, 2026

    Thank you so much.  This has worked for me.  I'm very grateful!  🙏

Resources