Formula Help-returning False
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! |
Formula Help-returning False
Perhaps this is what you meant to do:
=IF(Roster!$A8="I","",IF(AND(Roster!$A8="A",Roster !$H8="Y"),Roster!B8,"")) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Wilma" wrote: 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! |
Formula Help-returning False
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? "Max" wrote: Perhaps this is what you meant to do: =IF(Roster!$A8="I","",IF(AND(Roster!$A8="A",Roster !$H8="Y"),Roster!B8,"")) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Wilma" wrote: 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! |
Formula Help-returning False
"Wilma" wrote:
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 --- |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com