Hello,

I have re-formatted those cells. after it, I key-in the function in an empty
cell. but it doesn't work.

BR
Viesta

"MartinW" wrote:

Hi Viesta,

I'm afraid you are starting to confuse me.
I think your problem is that you are trying to reformat the cells
after you have entered your formulas. In this instance I think
you should be formatting all your cells before you do anything.
If this is not the case please explain your problem in more detail.

HTH
Martin