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
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