thanks Joe, i went with the first one and it worked... YEAH....:)

"joeu2004" wrote:

On Nov 13, 1:18 pm, Oregongal35
wrote:
Sorry this is my formula,
[....]
=IF(roc1*2%<500," 500",roc1*2%)

=if(roc1*2% < 500, 500, round(roc1*2%,0))

Note that I replaced " 500" with just 500. If instead you want the
result to always be text with one leading space, try:

=if(roc1*2% < 500, " 500", text(roc1*2%, " 0"))

Note that the TEXT() function does the rounding for you. Also note
that there is a space before 0 in the last term.

More simply, replace the IF() function with one of the following:

=round(min(roc1*2%,500), 0)

=text(min(roc1*2%,50), " 0")