Try
=IF(AND(G1700,I170<=0,LEN(I170)0),"No Charge Made","")

Hope this helps,

Hutch

"Sean" wrote:

I have a s/s which I want to produce a statement based on 2 cells

G170 is a cell that contails a sum (if cells above are filled it it will add
them up)

I170 contains a cost

if G170 & i170 are blank then do nothing
If G170 is greater than 0 and I170 is greater than 0 then again do nothing
but if G170 is greater than 0 and I170 is = < 0 then "No Charge Made"

Can anyone help all I get is FALSE

I have tried =if(g170<=0, and (i170=<0,No Charge made",""))