Forum Discussion
Solved
NESTED IF and AND formula help please
Hi Excel Gurus Back in November I found some answers to my queries here in the forum, however between then and now I've managed to mess the formulas up. I went back and copied the previous formula...
Yes - a text value is greater than ANY number, not just 0.
So if D6 equals "TM", the formula
=IFS(D6>1, "Greater than 1", D6="TM", "Equals TM")
will return "Greater than 1".
HansVogelaar Thanks Hans for your answers. I wonder if you could answer one more question please.
I was wondering if I said if D6>1 would that then stop D6=TM being a true answer?
Thanks
Pam
Yes - a text value is greater than ANY number, not just 0.
So if D6 equals "TM", the formula
=IFS(D6>1, "Greater than 1", D6="TM", "Equals TM")
will return "Greater than 1".
HansVogelaar Thanks Hans - hopefully this will give me what I need to get this formula correct.
I really appreciate you Excel Gurus being there.
Pam