Yes Peo, that works. Thanks alot

"Peo Sjoblom" wrote:

You need to use CEILING within the IF formula (multiple times I guess)
or else you'll get the error, maybe you can use

=IF(J25<90000,CEILING(0.062*I25,0.002),IF((90000-J24)*0.062<0,"No FICA
due",CEILING((90000-J24)*0.062,0.002)))


--

Regards,

Peo Sjoblom

"donnaK" wrote in message
...
Excel 2000.

This formula returns an error of #VALUE when I add the rounding, instead
of
the text "No Fica Due" Does anyone have any suggestions? I believe I
must
have the cell formatted as "number" for when the cell returns a numerical
value.

=CEILING(IF(IF(J25<90000,0.062*I25,(90000-J24)*0.062)<0,"No FICA
due",IF(J25<90000,0.062*I25,(90000-J24)*0.062)),0.002)