LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
TeachCTC
 
Posts: n/a
Default Can I get multiple values returned for an IF formula?

I have a simple table with student names in B2:L2 and words in A2:A221.
Under each student name next to the word, I put a 1 if they knew the word or
a 0 if they did not.
Question: Can I have the students name returned if they had a 0 in the box
for a particular word? Example: In A2 the word is 'the'. Under student A I
entered a 1, under student B a 0, and student C a 0, etc. I want a formula
that will return each name that has a 0 for that word.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy values generated by conditional formula in one sheet to the other work sheet as values ramana Excel Worksheet Functions 1 October 5th 05 01:04 PM
copy values generated by conditional formula in one sheet to the other work sheet as values bobby Excel Discussion (Misc queries) 1 October 5th 05 12:18 PM
Using returned values as part of another formula Duby Excel Worksheet Functions 3 October 1st 05 03:47 PM
How To Use Cells Without Values in a Formula Roger H. Excel Worksheet Functions 2 April 6th 05 01:01 AM
How to sum values in multiple worksheets Robert Lawrence Excel Worksheet Functions 3 January 29th 05 05:15 AM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"