Nested formular to give a word answer based on 2 cells

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

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",""))
 
Hi,

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

Hope this helps,

Hutch
 
Back
Top