Formula to round up

D

Doug

I need to round up to the nearest 1/4 dollar. If it was
$1.03 I need it to say $1.25 and if were $1.66 then it
would need to be $1.75 and so on. I just can't get the
ROUNDUP funtion to give me what I need. Any ideas.
 
T

tjtjjtjt

Assuming your number is in cell A1, try this

=CEILING(A1,.25

t

----- Doug wrote: ----

I need to round up to the nearest 1/4 dollar. If it was
$1.03 I need it to say $1.25 and if were $1.66 then it
would need to be $1.75 and so on. I just can't get the
ROUNDUP funtion to give me what I need. Any ideas
 
Top