Multiply and Roundup with parameters.

[cems]

[FONT=&quot]Column: Suggested Retail Price
It needs to be 3 times the new disc price and end in a 9. If the suggested retail is over $6, then it should end in .99. Also, if the new calculated retail is less than the You’re A/C retail Price, keep the You’re A/C retail price. So something 2.50 would be 2.59. Any way to do this? Any function or array do do this for the entire column?

-Thanks
[/FONT]

 

[cems]

Column C has to be 3 times Column D
If column C>6 Round to .99 (6 to 6.99)
If column C<6 Round to closest .09 (2.50 to 2.59)
If new calculated column C is less than column E then use E.
Any ideas?