Forum Discussion

Scholtar's avatar
Scholtar
Copper Contributor
May 26, 2023
Solved

Look at multiple values to give me a TRUE/FALSE

I'm trying to get Excell to give me a "Current" or "Uncurrent" value based on 2 different variables.   The variables are: Within the past 90 days over a range of 9999 cells More than 1.0 over a r...
Formulas and Functions
Macros and VBA
training
  • HansVogelaar's avatar
    HansVogelaar
    May 26, 2023

    Scholtar 

     

    =IF(SUMIFS(M4:M9999, B4:B9999, ">="&TODAY()-90)>1, "Current", "Uncurrent")

HansVogelaar's avatar
HansVogelaar
MVP
May 26, 2023

Scholtar 

Can you explain more clearly and in detail what you mean by

 

Within the past 90 days over a range of 9999 cells

More than 1.0 over a range on 9999 cells

 

and what exactly you want to do?

  • Scholtar's avatar
    Scholtar
    Copper Contributor
    May 26, 2023
    Sure!

    I want to look at dates in B4:B9999 and if it's within the last 90 days from today, move to the next step.
    THEN I want to look at values in cells M4:M9999 and if they add up to over 1.0 after meeting the previous steps criteria, I want to populate a "Current" message. If not, I want an "Uncurrent" message.

    Thanks in advance for helping, I've been pulling my hair out over this problem for 3 days now 🙂
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 26, 2023

      Scholtar 

       

      =IF(SUMIFS(M4:M9999, B4:B9999, ">="&TODAY()-90)>1, "Current", "Uncurrent")

      • Scholtar's avatar
        Scholtar
        Copper Contributor
        May 26, 2023
        THANK YOU!!! I figured it had to be multiple formulas, I just couldn't figure out how to combine them. So glad you solved in 30 min what's been kicking my butt for 3 days!!!! I hope you have a wonderful weekend superhero!!!!

Resources