Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel 2003 (IE 2008) formula question
Thank you, I will look into that.- Leena2012
- Post #5
- Forum: Microsoft: Office
-
Excel 2003 (IE 2008) formula question
I tried that but the zero appears in the c column instead of changing the information in the A column. In other words, if column B ("Status") says pending, then column A ("Bin") would tell you which bin the merchandise is in. But when column B says completed, the merchandise would be in bin 0...- Leena2012
- Post #3
- Forum: Microsoft: Office
-
Excel 2003 (IE 2008) formula question
I'm working in Excel 2003 (IE 2008). I want column A to change to zero only if column B says COMPLETED. If column B says PENDING or anything else, column A should remain the same. There are no other formulas in the spreadsheet. I appreciate any assistance on this. Thanks in advance!- Leena2012
- Thread
- Replies: 5
- Forum: Microsoft: Office
