View Single Post
  #1   Report Post  
peter via OfficeKB.com
 
Posts: n/a
Default Help me ! I want to create two or more functions work in one cell.

I want to create two or more functions to works in one cell, respectively:

IF(AND(B5=B21,A5=A22),SUM(C5),"") and IF(AND(B5=B21,A6=A22),SUM(C6),"")
Independently they work but when I’m ordering one by one in sell appears
FEALS.
I tried to apply before OR , IF(OR …. , but something’s wrong.

--
Message posted via http://www.officekb.com