IF condition

[MIchel Khennafi]

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

 

[Nick Hodge]

Michel

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]

 

[Ardus Petus]

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

HTH

 

[Elkar]

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