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]HIS


"MIchel Khennafi" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Ardus Petus]

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

HTH
--
AP

"MIchel Khennafi" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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
>
>

[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


"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
>
>
>