On 27 Jun 2005 13:31:04 -0700, "Tyson" wrote:





=IF(A1="Variance %", TEXT(your_formula,"0.00%"),TEXT(your_formula,"$0.0 0"))

If this is not satisfactory, post back and we'll derive a VBA solution.


--ron


Perfect!

Thanks Ron.

Tyson

You're welcome. Glad to help. Thanks for the feedback.

--ron