Forum Discussion
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 range on 9999 cells
I've tried using the SUMIFS formula, but it throws and error. When I use the IF formula it populates 9999 cells. I'm sure I'm close and just putting something in the wrong place, but even with tutorials I can get what I want over 9999 cells, or I get a "0". Any help is GREATLY appreciated!
I'm not opposed to using a Macro function either, but that's VERY far out of my depth so I'd need a step-by-step broken down for your Grandma.
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?
- 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 🙂
