View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wrosie
 
Posts: n/a
Default combining conditional statements

I'd like to combine three conditional statements into one statement.

The three conditionals:

=IF(E20,H2-E2,"")

=IF(F20,"","")

=IF(AND(E2=0,F2=0),H2-D2,"")

Is this possible?

Thanks!