0

I need to round down the highlighted numbers in Column Q of the attached screenshot. I currently have formula of P/F starting on Cell Q5 through Q46. I am diving the quantity on hand for each part number by the Qty Used per build. Is there a round down formula I can use to incorporate the P/F formula so it can round down the number in each cell automatically?

Thank you in advance, enter image description here Juan

Improve this question
3
  • 1
    wrap your formula in the ROUNDDOWN() formula?
    – Scott Craner
    Commented Jul 6, 2023 at 19:56
  • Hi Scott, I have tried this already but I get a message saying "You've entered too few arguments for this function". Here is the formula I used ---- =ROUNDDOWN(P5/F5)
    – Juan P.
    Commented Jul 7, 2023 at 12:33
  • did you read the link? it showed you how to use the formula and would explain why you are getting that error. =ROUNDDOWN(P5/F5,0)
    – Scott Craner
    Commented Jul 7, 2023 at 13:49

0

Reset to default

You must log in to answer this question.