Getting output # value

[mukeshbaviskar]

Hi friends,
If the cells are blank then I get '# value' a wrong output. If the cells are blank then the cell should be blank.

Please Login or Register  to view this content.

Solution please!

Thanking you in anticipation.

Regards,

Mukesh

[FDibbins]

That is testing if ALL of teh cells are blank, so if even just 1 is blank, the sum() will fire. maybe try OR instead of AND

[mukeshbaviskar]

Hi FDibbins,
Thank you for suggestion. 'or' solved the problem.

Thank you.

Regards,

Mukesh

[FDibbins]

happy to help and thanks fo rthe feedback