Mkt price close to Moving average

[Tenspeed39355]

Hi guys I am stuck again. Here is the problem. I want to be alerted when the market price is within 05 cents of the SMA. I can use conditional formating to change the color of the result. I do not know how to make a column to show what I am after. Can you help with this. Thanks for your time. I would like the result to be a dollar figure rather than a Percent but I will take anything
Max

[Cyberdude]

Are you working with formulas or VBA?
In general, it sounds like you want something like:

If(ABS(SMA - ClosingPrice) <= 0.05, then ...