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...
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.