Formula Help-returning False

W

Wilma

I need some help--the formula below gives me a blank cell if the value is
"I"--but what I want is that if the value is "I" to not return value--so that
only values of "A" will appear on my list.

In addition--when there is no data--it is returning a value of "False"--how
do I get it to return a blank cell?

=IF(Roster!$A8="I","",IF(Roster!$A8="A",IF(Roster!$H8="Y",INDEX(Roster!B8,0),"")))

Any help will be greatly appreciated!
 
W

Wilma

Max,
Thank you for your help --your formula worked! It returns a blank cell where
it appeared as "false" before!

Would you happen to know how to remove the blank rows? For the value
"I"-the formula returns a blank row--is there a way to eliminate the blank
rows for all values of "I" so the values for "A" appear sequential?
 
M

Max

Wilma said:
Max,
Thank you for your help --your formula worked! It returns a blank cell where
it appeared as "false" before!

That's good. Could you press the YES in that response, to close off your
query.
Would you happen to know how to remove the blank rows? ...

Suggest you start a new thread for your new query. Include more info.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top