IF formula

Closed
Sixhobbits - 28 Aug 2009 à 05:00
 Sixhobbits - 30 Aug 2009 à 13:39
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 responses

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
29 Aug 2009 à 06:59
use countif(range,"=x")
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