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 portion is correct and working and providing a value of 1

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

 

I'd like to add this to it (I18>1) and get a value of 2 if this is true.  If the value of I18<1, then I'd like to still see a value of 1.  

 

Can anyone help?  Thanks so much.  Cindy

 

excel
Formulas and Functions

5 Replies

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

Resources