Hi. I am not a rocket scientist -- of for that matter, very good with addition and subtraction, and I have to take a test for my job. Well, retake the test...
So, question, in Excel (and the test uses Windows 98), I need to create a formula that will place the word "yes" if the sales team meets or exceeds goal of $3000, and the word "no" if they do not. HELLLLLPPPPP!
Thanks :)
Assumed I have this sheet below:
| A | B
=====================
1 | SALES | GOAL
2 | 3000 | =IF(A2>2999,"YES","NO") -> copy too all cell below
3 | 2000 | =IF(A3>2999,"YES","NO")
4 | 2999 | =IF(A4>2999,"YES","NO")
Will be displayed as:
| A | B
=====================
1 | SALES | GOAL
2 | 3000 | YES
3 | 2000 | NO
4 | 2999 | NO
106 views
Usually answered in minutes!
×