Hello!
When i'm using this formula:
{=IF(AND(Pontaj!M9:V9="CFS";SUM(Pontaj!M9:V9)=0);"CFS";IF(AND(Pontaj!M9:V9="CO";SUM(Pontaj!M9:V9)=0);"CO";IF(AND(Pontaj!M9:V9="LP";SUM(Pontaj!M9:V9)=0);"LP";IF(AND(Pontaj!M9:V9="N";SUM(Pontaj!M9:V9)=0);"N";IF(AND(Pontaj!M9:V9="L";SUM(Pontaj!M9:V9)=0);"L";IF(AND(Pontaj!M9:V9="CM";SUM(Pontaj!M9:V9)=0);"CM";SUM(Pontaj!M9:V9)))))))} when the result it should be "CFS" or "CO" or "lp" etc., i get the result 0. What should i do to get the result "CFS"?
Thank you!
Bookmarks