mental block

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Lost said:
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.
Click to expand...

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