Formula - Product Function

Posted by: berry on 8 September 2017, 1:40 pm EST

  • Posted 8 September 2017, 1:40 pm EST

    Hi,


     


    I have a number cell type to which i set  a formula like PRODUCT(A1,B1)


    where both A1 and B1 cells are empty.


    However my result cell shows a default value of "1.0". The number cell type has once decimal place set.


    Unable to get rid of this default value. Please help.


     


    Regards,


    Priya

  • Replied 8 September 2017, 1:40 pm EST

    Priya -

    See the following thread for a discussion on this issue...

    http://www.clubfarpoint.com/Forums/forums/thread/70904.aspx

    The bug has been fixed and will be in the upcoming maintenance release.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels