View Single Post
  #6   Report Post  
Marie D
 
Posts: n/a
Default

=IF(AND(ISBLANK(A3), ISBLANK(B3), ISBLANK(C3)),"hai", IF(AND(ISBLANK(D3),
ISBLANK(E3)), "Hello","false"))

"joe" wrote:

I need to create a formula which states like this

IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then
'Hello')

Can you guys help