I just posted a nested if statement, but started thinking and thought this
would work better for you.
=IF(AND(ISBLANK(A1), ISBLANK(B1), ISBLANK(C1), D1<"", E1),"hai",
IF(AND(ISBLANK(A1), ISBLANK(B1), ISBLANK(C1),ISBLANK(D1), ISBLANK(E1)),
"Hello","?"))
"Marie D" wrote:
=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
|