View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AB[_2_] AB[_2_] is offline
external usenet poster
 
Posts: 236
Default Formula Help Please

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

On Mar 28, 7:49*am, Paul Black wrote:
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 F90 then SUM(E9:F9

Thanks in advance.

Regards,
Paul