|You didn't directly answer Question 1 or my final question.|
I'll try again:
1 - Do you want the macro to perform AVERAGE calculation and place it in B1 and then perform the IF function or do you want the macro to grab the (already averaged) value from B1 and then perform the IF function?
Final question: Since you said that the "The new values would be stored in another cell" why do you need a macro? A cell based IF function can certainly check the pos/neg status of B1 and do the required calculations.
I curious as to why you want to add the complexity of a macro when a cell based formula will work. I'm not saying that the macro will be very complex, because it won't be. I'm just wondering why you want to use a macro instead of a formula to perform this relatively simple task.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.