Perhaps you could let us know what formula you are using ... ?

Pete

Olga wrote:

I have a formula that is working. But in the cell that the formula is applied
to, it displays #N/A. When I go to the formula wizard it's displaying the
correct result. Any help would be greatly appreciated!