Defining cell with only through 1 - 32
 

Hi All
I want to define all the cells where the integer only goes to 32.
Meaning when I enter in A1 167.700.25 and A2 152.30 and I want to subtract
A1-A2 = 7.70 where the inetger goes to 100.

I my case I want it to go only to 32.(1/32)
Meaning if A1 110.15(.15 should be formated as actually .15*32= 0.048) so
instead of 110.15 I want the cell formated so I can input 110.15 and it
writes as 110.048. OR it even if it lets me input 110.048 is fine which ever
is possible.

The reason I want it done is because I am dealing with interger which are
expressed in 32nds. thats is 1/32, 2/32, 3/32, 4/32, 5/32.....so on. where
1/32 = 0.031^, 2/32=0.063^....... and so on.

The final output I am looking for is if I want to subtract 110^17 (^17 =
17/32)
from 111^10 (^10 = 10/32)
The answer should be 111^10 - 110^17 = ^25

hope you understand how I get that ,
i want excel to do this for me.

Hope someone can help
Regards
Zee

Defining cell with only through 1 - 32
 

Maybe a custom number format? Format/Cells/Custom, enter
# ??/32

Enter your number as mixed numbers
111 10/32 - 110 17/32 = 25/32 (or 0.78 if the answer is formatted as a
decimal).


"Zee" wrote:

Hi All
I want to define all the cells where the integer only goes to 32.
Meaning when I enter in A1 167.700.25 and A2 152.30 and I want to subtract
A1-A2 = 7.70 where the inetger goes to 100.

I my case I want it to go only to 32.(1/32)
Meaning if A1 110.15(.15 should be formated as actually .15*32= 0.048) so
instead of 110.15 I want the cell formated so I can input 110.15 and it
writes as 110.048. OR it even if it lets me input 110.048 is fine which ever
is possible.

The reason I want it done is because I am dealing with interger which are
expressed in 32nds. thats is 1/32, 2/32, 3/32, 4/32, 5/32.....so on. where
1/32 = 0.031^, 2/32=0.063^....... and so on.

The final output I am looking for is if I want to subtract 110^17 (^17 =
17/32)
from 111^10 (^10 = 10/32)
The answer should be 111^10 - 110^17 = ^25

hope you understand how I get that ,
i want excel to do this for me.

Hope someone can help
Regards
Zee

Defining cell with only through 1 - 32
 

Forgot one other thing - you could also enter the number as a decimal and it
will be displayed as a mixed number

110.048 is displayed as 110 2/32 (rounded, however the value is still stored
as 110.048).



"JMB" wrote:

Maybe a custom number format? Format/Cells/Custom, enter
# ??/32

Enter your number as mixed numbers
111 10/32 - 110 17/32 = 25/32 (or 0.78 if the answer is formatted as a
decimal).


"Zee" wrote:

Hi All
I want to define all the cells where the integer only goes to 32.
Meaning when I enter in A1 167.700.25 and A2 152.30 and I want to subtract
A1-A2 = 7.70 where the inetger goes to 100.

I my case I want it to go only to 32.(1/32)
Meaning if A1 110.15(.15 should be formated as actually .15*32= 0.048) so
instead of 110.15 I want the cell formated so I can input 110.15 and it
writes as 110.048. OR it even if it lets me input 110.048 is fine which ever
is possible.

The reason I want it done is because I am dealing with interger which are
expressed in 32nds. thats is 1/32, 2/32, 3/32, 4/32, 5/32.....so on. where
1/32 = 0.031^, 2/32=0.063^....... and so on.

The final output I am looking for is if I want to subtract 110^17 (^17 =
17/32)
from 111^10 (^10 = 10/32)
The answer should be 111^10 - 110^17 = ^25

hope you understand how I get that ,
i want excel to do this for me.

Hope someone can help
Regards
Zee