Sorry this is my formula,

I cant get it to work when i try to round the last part.

=IF(roc1*2%<500," 500",roc1*2%)


Thanks..

"Shane Devenshire" wrote:

Hi,

Probably

=ROUND(IF(A1=15,A1*25%,0),2)

You didn't show us the formula you were using so I made one up

Cheers,
Shane Devenshire

"Oregongal35" wrote:

I created a true and false function,
and if true then it equals 33*25%, how do i get the that number to round in
my formula?