Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Dionysus
How do I use the AND function in Excel?
I want to set several different percentages to several ranges of income, BUT the income varies if the situation is for a single person, married person, etc.
This is part of my failed equation, but you might understand my thinking...
=IF(AND(B43="single", D13<33950,"15")).
There may be an easier way, but I dont know it. Please advise!
1 AnswerOther - Computers1 decade agoHow do I show a sum of 0 in Excel?
Actually, I can show a 0 when the number is < 0, BUT the cell in question is part of another equation and it still calculates as the negative number. I've formated the cell as: General;"0"
2 AnswersOther - Computers1 decade ago