roundup to next even number

Nancy Lee · May 29, 2004

I use this formula
=SUM(A2*B2)/144
and need to roundup - but to the next even number
so if calc returns 21.75 sb 22.00 or if 22.10 sb 24.00
I am brand new to this - any help would be appreciate

Frank Kabel · May 30, 2004

Hi
one way:
=ROUNDUP(A1/2,0)*2

or use
=CEILING(A1,2)

Peo Sjoblom · May 30, 2004

One way

=EVEN((A2*B2)/144)

no need for sum

--

For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

CLR · May 30, 2004

=ROUNDUP((SUM(a2*b2)/144)/2,0)*2

Vaya con Dios,
Chuck, CABGx3

roundup to next even number

Nancy Lee

Frank Kabel

Peo Sjoblom

CLR