mental block

[Guest]

I can not figure out the formula that I need to perform the following........
If a cell =0 then i want to take the greater of two sums. If the cell does
not = 0, then another formula. Here is what I have
=IF(I3=0,(MAXSUM(K3*4.5);M3*1.1-K3)),SUM(J3/I3*N3*1.1))

Would appreciate your help.

thanks

 

[David Biddulph]

=IF(I3=0,MAX(K3*4.5,M3*1.1-K3),J3/I3*N3*1.1)

 

[joeu2004]

I can not figure out the formula that I need to perform the following........
If a cell =0 then i want to take the greater of two sums. If the cell does
not = 0, then another formula. Here is what I have
=IF(I3=0,(MAXSUM(K3*4.5);M3*1.1-K3)),SUM(J3/I3*N3*1.1))
Would appreciate your help.

Well, I do not see any sums per se, and syntax ambiguities, which I am
sure you are aware of and struggling with, your intent is unclear.
Perhaps something like:

=if(I3=0, max(K3*4.5, M3*1.1-K3), 1.1*N3*J3/I3)

Note that I reversed the order of some terms in the last expression.
That should make your intent clear without the need for superfluous and
often obfuscating parentheses. However, you might have meant the
following or some variation, which requires parentheses as shown:

J3/(I3*N3*1.1)

 

[Guest]

David,
Thank you very much. You are the greatest.
Greg