This is my first post and I really don't know what the function is called or even if it is possible, so I am not really able to do a search.. Please be open-minded at my noobness.
I am trying to make a formula that will exclude any number other than a full batch count. For example
My batch is 333 and every one batch = 1000. So I would like my formula to = the output for the number of full batches in increments of 333.
Simplified:
a = 1000/333 where a is the actual input
if a is 333, then the output is 1000
if a is 666 (coincidence) than the output is 2000
if a is 331 the output is zero
and if a is 334-665 the output is 1000
any ideas? I am wracking my brain over this to find an exclusion logical statement. I know where i need to be, just not what it's called or how to get there.
Bookmarks