Thread: IF Dilema
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default IF Dilema

On Sun, 24 Dec 2006 08:37:00 -0800, Shu of AZ
wrote:

Thanks Ron, I tried your formula and received a value error.


That will happen if the first argument of the CHOOSE function is not [1-5].


--ron