roundup to next even number

[Nancy Lee]

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]

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

or use
=CEILING(A1,2)

 

[Peo Sjoblom]

One way

=EVEN((A2*B2)/144)

no need for sum

--


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

Regards,

Peo Sjoblom

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3