Share via

Excel Function Argument won't display

Anonymous
2020-09-01T21:48:44+00:00

I input the cells and number for a PRODUCT Function Argument, and the result displays in the Function Argument window.  But when I click OK, the destination cell shows a result of 0.000

The other functions in the worksheet are working.  Why would this one not work?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2020-09-03T07:32:50+00:00

    We need to see that file.

    Login to https://onedrive.live.com/ (Use the same Login ID and password as for this forum).

    Click Upload in the top and choose your file.

    After uploading, right click the file and choose share.

    Click Get a Link.

    Copy the link and paste it here.

    Andreas.

    0 comments
  2. Anonymous
    2020-09-03T12:31:21+00:00

    Hi,

    It works for me on my copy of Excel.  Is there anything odd about the numbers - are any stored as text?  What happens if you do =f4*A143*0.00001 instead of using the product function? 

    You could try removing each of the 3 arguments in turn to see if the formula resolves correctly.  that is, if product(f4, A143) returns the correct amount, then you at least know the the formula has an issue with the 3rd argument.  Once you know the one that is tripping up the function you can look at that cell to see why.  You could also try wrapping the arguments in value functions eg =product(value(f4), value(A143), 0.00001)

    Regards,

    Tony

    0 comments