On Thu, 3 Mar 2005 17:17:12 -0800, "lots of questions"
wrote:

can whole numbers be "rounded" in excel, either with
the "round" function or thru vba?

I have some calculations that I wish to display the
results as follows:

if results = o-24 then round down to 0
if results = 25-49 then round up to 50

If I understand you correctly, you wish to round your number to the nearest 50.

With your number in A1:

=ROUND(A1/50,0)*50

or:

=ROUND(your_formula/50,0)*50




--ron