Thread: how will i create a formula that will copy the content
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Casey[_102_] Casey[_102_] is offline
external usenet poster
  
Posts: 1
Default how will i create a formula that will copy the content

Try:

=IF(AND(A1B2,A11),A1,IF(AND(B2A1,B21),B2,0))
Returns 0 if neither cell is greater than the other or are less than
1.
HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=550075

Reply With QuoteReply With Quote