IF formula

[Rains]

I am currently struggling with a formula within excel. I have created a list box and a list of dates with the cell link in cell F1. i have a value in cell E7 and a number in AH4. my formula is :-

=if(and(F1=1,E7>0),AH4+1,AH4)

What i'm trying to achieve is that if F1 does not = 1 and E7 is not > 0 then display nothing, zilch..... but it will always display the value in AH4 ???


Help anybody please.....

[/b]

[LTunnicliffe]

Well, try:

=if(and(F1=1, E7<0),YourFormula,0)

I'm not sure what your formula is but you can put it in there. Hope this helps!

[TheClayTaurus]

you haven't put anything in to tell it to put "zilch" in

right now its always going to either output AH4+1 or AH4

make sense?

[HalfAce]

Try this:

=IF(AND(F1=1,E7>0),AH4+1,””)

Hope it helps.

[Rains]

Thank you all for you responses but maybe i should elaborate further :-

=IF(AND(F1=1,E7>0),AH4+1,””) works fine but what i really want is to say that

=IF(AND(F1=1,E7>0),AH4+1,AH4,"") what i want is a 3rd statement ???

i don't what the cell to show any figures if F1=1, E7>0 is false bit if true then i want either AH4+1 or AH4...

I know this sounds confusing but it would be easier to show than explain!!!

[Northerner]

Not sure what you third requirement is but Nest your IFs.
IF(AND(A1=1,B1=1),"A1+B1=1",IF(and(A1=1,B1=2),"A1=1 and B1=2"),"Nothing")

You can 'Nest' up to 7 IFs within themselves.
Hope this helps

[bosco_yip]

1) Your F1 appeared not a value, so that the formula cannot be worked

2) Try :
=IF(AND(F1=1&"",E7>0),AH4+1,AH4)

Hope can helps

Regards
Bosco