Forum Discussion

afprinter's avatar
afprinter
Copper Contributor
Jun 20, 2019
Solved

Need Help with a Formula for division with multiple variables.

I need help with a formula for: with the variable that only when M is over 250 to divide M by 2 to display it in N & O, when M is over 500 to divide M by 3 to display it in N, O, & P, when M is ove...
excel
Excel on Mac
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 20, 2019

    afprinter 

    When

    =IF(COLUMN()-COLUMN($M3)>(INT($M3/250)+1),0,$M3/(INT($M3/250)+1))*($M3>=250)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 20, 2019

afprinter 

 

It could be like

=IF(COLUMN()-COLUMN($M3)>(INT($M3/250)+1),0,$M3/(INT($M3/250)+1))

in N3 and drag it to another cells

  • afprinter's avatar
    afprinter
    Copper Contributor
    Jun 20, 2019
    If I copy this formula into N3 and the other cells, I get 206 in N and 0 in O, P, & Q.
    It works for Row 4.
    Is there a way to get N3 to not display 206 where it is under 250?
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 20, 2019

      afprinter 

      When

      =IF(COLUMN()-COLUMN($M3)>(INT($M3/250)+1),0,$M3/(INT($M3/250)+1))*($M3>=250)
      • afprinter's avatar
        afprinter
        Copper Contributor
        Jun 20, 2019
        That works awesome!

        Now, is it possible to add Column I in the formula for N only when N has a value greater than zero?

Resources