View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default if & And condition

On Sun, 24 Jan 2010 03:44:06 -0500, shajizz
wrote:


Dear friends..

I want to use fromula that if one logical condition is correct want to
go another logical condition eg:- If A20=<B20, only I want to check
C20=<D20, if A20=<B20 is not true iwant to check D20=<E20, anybody can
help me please..



Try this formula:

=IF(A20<=B20,C20<=D20,D20<=E20)

Hope this helps / Lars-Åke