Forum Discussion
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...
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?
It works for Row 4.
Is there a way to get N3 to not display 206 where it is under 250?
- 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?Value in N is greater than zero if only value in M is greater of equal than 250. With checking what we are in column N the formula could be
=(IF(COLUMN()-COLUMN($M3)>(INT($M3/250)+1),0,$M3/(INT($M3/250)+1))+$I3*(COLUMN()=COLUMN($N$1)))*($M3>=250)
- Thank you SOOOO much!!!! I could never have done this!