IF condition
 

Good afternoon to all

1 - How do I need to create my IF formula if I need to check to conditions,
for instance IF A1 is empty or null and if A2 is empty or null THEN...

2 - Is there a topic in the help menu that explains how to use if to test
several conditions... or any white paper or any other documentation online
(pdf file...)

Thanks so much guys,

Michel

IF condition
 

Michel

=IF(AND(A1="",A2=""),Do_This,Else_Do_This)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"MIchel Khennafi" wrote in message
...
Good afternoon to all

1 - How do I need to create my IF formula if I need to check to
conditions, for instance IF A1 is empty or null and if A2 is empty or null
THEN...

2 - Is there a topic in the help menu that explains how to use if to test
several conditions... or any white paper or any other documentation online
(pdf file...)

Thanks so much guys,

Michel

IF condition
 

For instance, question #1:
=IF(OR(ISBLANK(A1),ISBLANK(A2)),TRUE,FALSE)

HTH
--
AP

"MIchel Khennafi" a écrit dans le message de
...
Good afternoon to all

1 - How do I need to create my IF formula if I need to check to
conditions,
for instance IF A1 is empty or null and if A2 is empty or null THEN...

2 - Is there a topic in the help menu that explains how to use if to test
several conditions... or any white paper or any other documentation online
(pdf file...)

Thanks so much guys,

Michel

IF condition
 

Lookup help on the AND and OR functions.

=IF(AND(A1="",B1=""),TRUE,FALSE)

Also, you may find the help topic on "nesting functions" helpful as well.

HTH,
Elkar


"MIchel Khennafi" wrote:

Good afternoon to all

1 - How do I need to create my IF formula if I need to check to conditions,
for instance IF A1 is empty or null and if A2 is empty or null THEN...

2 - Is there a topic in the help menu that explains how to use if to test
several conditions... or any white paper or any other documentation online
(pdf file...)

Thanks so much guys,

Michel