Forum Discussion

Cindy_TBFL's avatar
Cindy_TBFL
Copper Contributor
Jan 04, 2022

Excel Formulas with multiple functions

Hi there... I'm trying to use something like this formula, but I keep getting an error....   =IF((I18<1),AND(O$14>=$J18,O$14<=$K18),1)OR((I18>2),AND(O$14>=$J18,O$14<=$K18),2)   I know this portio...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Jan 04, 2022

Cindy_TBFL 

Does this do what you want?

 

=IF(AND(O$14>=$J18,O$14<=$K18),IF(I18<1,1,2),"")

  • Cindy_TBFL's avatar
    Cindy_TBFL
    Copper Contributor
    Jan 04, 2022

    HansVogelaar 

    Thanks for your reply.

     

    Close - I still need to plan for I18>1, 2

    I'm still getting a notification there are too many formulas for the cell.  Any thoughts?

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jan 04, 2022

      Cindy_TBFL 

      The formula that I posted doesn't cause an error; if you get an error message there must be another problem.

      Could you explain as clearly as you can what the formula should return in each circumstance?

      • Cindy_TBFL's avatar
        Cindy_TBFL
        Copper Contributor
        Jan 05, 2022

        HansVogelaar 

        Please see my snapshot below.  My goal is to continue to use the "start" and "complete" dates to generate a value to the cells in the "calendar".  Additionally I'd like to assign a second fill color to differentiate between the project heading and phase columns within the project.  Project headings have no value in the "phase days" column, so I thought this would be a way to calculate various values to those cells allowing me to use conditional formatting to manipulate the fill colors. This is where I seem to be getting it wrong.

         

Resources