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