Nested formular to give a word answer based on 2 cells
 

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

Nested formular to give a word answer based on 2 cells
 

Hi,

=IF(AND(G170="",I170=""),"",IF(AND(G1700,I1700), "",IF(AND(G1700,I170<=0),"No Charge Made")))

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

Nested formular to give a word answer based on 2 cells
 

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

Nested formular to give a word answer based on 2 cells
 

Great - thanks
"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",""))

Nested formular to give a word answer based on 2 cells
 

Many thanks

"Tom Hutchins" wrote:

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