I got this to work, but I had to move it into a different cell to work.
=IF(AR16AR17,(AR16-AR17)*AR19)
I wanted it at the end of this formula in the same cell as my answer is in.
But I could Not get it to work.

Thanks
"Ron Rosenfeld" wrote:

On Thu, 29 Sep 2005 06:29:04 -0700, "susan slate" <susan
wrote:

If my answer is .13, .38, .63, .88 I need it to roundup to .25, .50, .75, 1.00


=ROUND(A1*4,0)/4

will do what you say.

It will also give the following:

0.12 0
0.37 0.25
0.62 0.5
0.87 0.75


If that is not what you want, post back.


--ron