Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula (IF) question
Greetings,
I do tech support (Exchange) for a school district, and I have been approached with an Excel question by one of the users. I am fairly skilled with Excel, but formulas are a weakness for me. In a simplified form, here is the problem. cells A1:E1 list the names of school cells A2:E2 list a value (in this case, a checkmark) that the end user is looking for in cell F2 is a formula that will look at cells A2:E2, and if all the cells are checked, will return one value, if all the cells are unchecked, will return a second value, and if only some are checked, will return a third value. Any thoughts? I have tried playing with IF formulas, but have not had much success. Thanks In Advance. -Drew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula Question...PLEASE PLEASE help! | Excel Worksheet Functions | |||
Formula Question IF/Lookup???? | Excel Worksheet Functions | |||
Formula Question.....PLEASE PLEASE help! | Excel Discussion (Misc queries) | |||
Parsing Data w/ a Formula (another question) | Excel Worksheet Functions |