How do I write the following condition in one cell (AA)?
cell 'C' - year bought
cell 'J' - bought commission
cell 'Q' - year sold
cell 'U' - sold commission
Cell 'AA' 2005 commission

if c4=2005,q4=2005 sum(j4,u4) if c4<2005,q4=2005 sum(0,u4)
if c4=2005,q4not=2005 sum(j4,0)

What is a good book that explain each function and gives good examples, I
can buy