For every X, add Y

[Citruslmn]

Hey!


So I'm stuck on this assignment.

Basically I've been trying to figure out for the last half an hour how to make a certain function.


As the title say, for every 50, add 1 but return 0 if less than 50. Last part might not be necessary. I could only find if it is less than X, return true else return false.


Thanks!

 

[Hui]

=INT(A1/50)


But if you have values less than 0

=(A1>0)*INT(A1/50)

 

[Citruslmn]

Awesome, it was that simple. Thanks a lot, now I can continue.