I have the following list of $$ amounts in column A with corresponding
calculation in column B (calculating markup).....

In column A In Column B (cell values are set to currency with 2
decimal places - rounding it)

$3.30 =((3.30*2)+(3.30*2*0.03)+0.6) = 7.40
$8.30 =((8.30*2)+(8.30*2*0.03)+0.6) = 17.70
$2.95 =((2.95*2)+(2.95*2*0.03)+0.6) = 6.68

What I need, is to fix the column B function so that the result is if the
"cents" are < 50 then add a calculation so that it the dollar amount remains
the same but the cents display .95 (i.e., instead of 7.40, it would be
7.95) and if the cents are 50 and above, then add the calculation so the
cents displayed are .99 (i.e., instead of 17.70, it would be 17.99 or 6.68
would display as 6.99).

Hope I've explained this well enough.

Thanks,
Don