Help With This Formula

[hp75150]

I have the formula =(sum(n2,p2,r2,t2)-max(n2,p2,r2,t2))/3 I need to know how to round the answer down to the whole number. Please help

 

[adam087]

Wrap it in =INT()

=INT(your_formula)

Hope that helps

/AJ

 

[AlKey]

Or this

=ROUNDDOWN(SUM(N2,P2,R2,T2)-MAX(N2,P2,R2,T2)/3,0)

 

[hp75150]

I,ve tried that. My annswer with just the formula is 1.366667 Once i add INT it becomes 1.333333? I'm stumped

 

[adam087]

Oooh. Yes. Or

=FLOOR(your_formula, 1)

Or xL 2010+

=FLOOR.PRECISE(your_formula, 1)

/AJ

 

[adam087]

I,ve tried that. My annswer with just the formula is 1.366667 Once i add INT it becomes 1.333333? I'm stumped

Can you paste the entire formula you're using there?

/AJ

 

[hp75150]

i GOT IT it was =rounddown(sum(field-Max(Field))/3,0