If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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","")) |
#2
|
|||
|
|||
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","")) |
#3
|
|||
|
|||
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","")) |
#4
|
|||
|
|||
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","")) |
#5
|
|||
|
|||
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","")) |
Thread Tools | |
Display Modes | |
|
|