View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default nestedif function

Hi Dave,

I deleted the calculation in the first row of the NestedIf column and
copied
the function from another cell and pasted it there.


Suddenly it calculates correctly


Weird.


In that case, almost certainly, the P1 and P2 arguments passed to the
function were incorrect.

---
Regards,
Norman



"Dave F" wrote in message
...
Well, I did something different than what I say below.

I deleted the calculation in the first row of the NestedIf column and
copied
the function from another cell and pasted it there.

Suddenly it calculates correctly.

Weird.