Feb 10 2020 04:15 AM
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 0.5 meters but if we have a screen of 11.50 meter we want a formula that says you need 11 brackets of 1 meter and 1 of 0.50 how can I make this formula .
I would like to hear from you
Kind regards, Barry van Tunen
Feb 10 2020 06:50 AM - edited Feb 10 2020 06:52 AM
Assuming that your screens always are always sized by increments of half a meter, the number of meters will be
=INT(size)
and the half meters will be
=IFERROR(0.5/(size-int(size),0)
or
=IFERROR(0.5/MOD(size,1),0)
But this last one will always return 1 or 0.
The attached file has a simple example.
Feb 10 2020 06:55 AM
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)