Formula Help Please

[Paul Black]

Good morning,

I am having a bit of trouble with this formula.. Would I would like
is ...

If G8=0 AND If E9=0 put "" BUT

If G8=0 and If E9=0 and If F9>0 then SUM(E9:F9

Thanks in advance.

Regards,
Paul

 

[AB]

There are some scenarios that you haven't catered for but you can try
this:
=IF(AND(G8=0,E9=0),IF(F9>0,SUM(E9:F9),""))

 

[joeu2004]

If G8=0 AND If E9=0 put "" BUT
If G8=0 and If E9=0 and If F9>0 then SUM(E9:F9

Perhaps:

=IF(AND(G8=0,E9=0,F9>0),SUM(E9:F9),"")