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.

       

      • Cindy_TBFL's avatar
        Cindy_TBFL
        Copper Contributor
        Jan 05, 2022
        HansVogelaar
        Below is a dropbox link to the file for reference. Thanks very much for your thoughts on this formula.
        https://www.dropbox.com/sh/gvy9p2qktgg9c0o/AADVM8yckQOtt8ICmlj1A-Sua?dl=0

Resources