Nested formular to give a word answer based on 2 cells

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

Eduardo

Hi,

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

Tom Hutchins

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

Hope this helps,

Hutch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Use TODAY() function as the criteria in a SUMIF formula 1
Adding cells until they are greater than a lookup cell and returning a value 1
Moving Cells 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
return different values based on 4 criteria? 4
sumif across multiple sheets in excel 2007 based on a condition 8
Nested Formula 2

Top