mental block
 

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

mental block
 

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

"Lost in excel" <Lost in wrote in message
...
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

mental block
 

Lost in excel wrote:
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)

mental block
 

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


"David Biddulph" wrote:

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

"Lost in excel" <Lost in wrote in message
...
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