R
Rait
Hi,
Making templete file to my documents, but faced small problems.
Hope someone can point out how to get over it.
What im trying to do:
cell A - nominal value
cell b - upper tolerance
cell C - lower tolerance
cell d - actual value
now i have check where it compares actual value, will it be inside
tolerances, if not it will mark it red (simple conditional formating)
1st problem :
In cells A i want cell take decimal amount from my typed entry.
10.000 , 10.00, 10.0 or 10. In different documents same cell can have
different amount of decimals.
Like when i type in 10.000 it keeps 3 decimals, if 10.0 it keeps 1
decimal.
2nd problem :
I want cells b,c,d take decimal amount from cell a.
All ideas welcome
Rait
Making templete file to my documents, but faced small problems.
Hope someone can point out how to get over it.
What im trying to do:
cell A - nominal value
cell b - upper tolerance
cell C - lower tolerance
cell d - actual value
now i have check where it compares actual value, will it be inside
tolerances, if not it will mark it red (simple conditional formating)
1st problem :
In cells A i want cell take decimal amount from my typed entry.
10.000 , 10.00, 10.0 or 10. In different documents same cell can have
different amount of decimals.
Like when i type in 10.000 it keeps 3 decimals, if 10.0 it keeps 1
decimal.
2nd problem :
I want cells b,c,d take decimal amount from cell a.
All ideas welcome
Rait