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