IF formula

Closed
Sixhobbits - Aug 28, 2009 at 05:00 AM
 Sixhobbits - Aug 30, 2009 at 01:39 PM
Hello,

I am trying to write an IF formula in sheet1 which returns "true" if ANY CELL in sheet2 = "x". Is this possible?

Thanks,

Sixhobbits

2 replies

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 29, 2009 at 06:59 AM
use countif(range,"=x")
0
Thanks.

Another query: If I have two dates – an arival date and departure date – can excel display all dates between those two dates? So, if I have 2 September 2009 and 5 September 2009, how can I display (in seperate cells) 2 September, 3 September, 4 September, 5 September?

Thanks a lot for your help,

S
0