Thread: IF condition
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default 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