I am trying to create a formula that will automatically populate a statement in Column E but conditions are based on information in columns C & D. This is what I want to be in Column E: =IF(D3=>0,"Y","Pend").

However, the information in column C determines if the statement in Column E is necessary. I want to create the statement to read if there is nothing in Column C, then leave Column E blank.

I am using Column C as a input Cell and the formula in Column D is (Column B-Column C). If I have not input anything in Column C, then there is no need for the pending or yes statement in Column E.

This involves 2 conditions, I'm thinking "If and "AND" but when I tried to add them together using the following formula but it was incorrect:
=IF(D3=>0,"Y","Pend"), AND(C3>0)).