Help with cell formula, please...

[zSplash]

Here's the formula I'm trying to give a cell:

=IF(SUM(O22)=0 or if (sum(O22=""),"",O2/(SUM(O2+P2)))

I get an error.

The following code works just fine...

=IF(SUM(O22)=0),"",O2/(SUM(O2+P2)))

....but when I try to add the additional (or if sum(O22="")), I am told
there is an error but given absolutely no direction as to what could be
wrong.

I constantly get errors when I try to write formulas for cells. What is
wrong this time?

TIA

 

[Trevor Shuttleworth]

=IF(OR(SUM(O22)=0,SUM(O22)=""),"",O2/(SUM(O2+P2)))

Regards

Trevor

 

[Toby Erkson]

Go into Help and look up "OR worksheet function". Just like AND, it's kinda
funky and not, in my opinion, a logical method.

 

[Toby Erkson]

Oh, I was just going to show how but ya beat me to it!

 

[zSplash]

Thanks Trevor and Toby. You're awesome!

st.