Formula Help-returning False

  • Thread starter Thread starter Wilma
  • Start date Start date
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!
 
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?
 
Wilma said:
Max,
Thank you for your help --your formula worked! It returns a blank cell where
it appeared as "false" before!
Click to expand...

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? ...
Click to expand...

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
---
 
Back
Top