Forum Discussion
formula excel with fixed sharing options to zero
a good morning. I had an excel question. am creating an excel document where we can confuse LED screens with what do you need when you make this. now we have fixed sizes of brackets of 1 meter and...
Hello bvt_events,
There are many ways that this could be accomplished. Here is one method:
For the amount of 1 meter brackets
=QUOTIENT(A1,1)
For the amount of 0.5 meter brackets
=2*MOD(A1,1)