Thanks guys

"Dave Peterson" wrote:

=if(and(a1="",b1="",c1=""),"hai",if(and(d1="",e1=" "),"hello","what goes here?"))

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

--

Dave Peterson