Formula Help Please

  • Thread starter Thread starter Paul Black
  • Start date Start date
P

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