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".
The problem is that Excel treats text values as greater than all numbers (including 0), so "TM">0.
Solution: switch the two parts in IFS. In D7:
=IFERROR(IFS(D6="TM",5*6,D$6>0,B7*$D$6),0)
Fill to the right.