Need help with new multiple if statement

[beancounter]

Two formulas required

I'll give you the data points rather than the mess I made. all on row 14, in columns D, I & J there are amounts. What I am hopeing to do is in column L, If column D & I are each greater than 1 Multiply Column D by Column J.

In column M, If Column D is less than 1 & I is greater than 1, Multiply column D by Column J.

Also, does anyone know where (besides this board) I can get a good "cheat sheet" on developing more complex formulas?

thanks,
John

 

[Jonmo1]

In L14
=IF(AND(D14>1,I14>1),D14*J14,"")

In M14
=IF(AND(D14<1,I14>1)D14*J14,"")