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

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