Conditional formating

[successorsdata]

Could you help me to write the formula for this problem

A	B	C	D
Buy	110	109	Sell Now
Sell	109	110	Buy Now

If A="Buy" & B>C then D="Sell Now"
If A="Buy" & B<C then D="Buy Now"
If A="Sell" & B<C then D="Buy Now"
If A="Sell" & B>C then D="Sell Now"

If know how to use this formula =D(if110>109,"Buy Now",Sell Now") but I can not add the condition for "A" to it in one formula.

Sincerely,
Morry

 

[Dermot]

formula for D1
= If(AND(B1>C1,A1="Buy"),"Buy Now","Sell Now")