Nevermind it was just my very tired mind.....

"MLShef" wrote:

I am using the following formula

=IF((F2*0.85)(E2*1.1),(ROUND(F2*0.85,0)),(ROUND(E 2*1.09,0)))

the result rounds the number to the nearest $5 but I want it rounded up to
the nearest $1. Can someone help? I am sure this is easy but......