Lowell In the south
Board Regular
- Joined
- Sep 26, 2002
- Messages
- 55
I need to be able to check the result of a formula for 32nds of an inch. If my formula returns a 32nd any 32nd 1/32, 3/32,...29/32 ect. I will some how (Macro or Function) sub tract a 1/16 from one of the user inputs to in effect round the result. Due to my application I am unable to simply round the result as it would not be the true result.
I had thougt of using a IF function that checked the cell for .****5 as a 32nd will always have a 5 in the fifth place after the decimal. But the functions dont like * for any charcter approch. SO I am looking of help!!!!!!!!!!!!!
THANKS!! FOR LOOKING!!!!!!!!!!!!!!!!
I had thougt of using a IF function that checked the cell for .****5 as a 32nd will always have a 5 in the fifth place after the decimal. But the functions dont like * for any charcter approch. SO I am looking of help!!!!!!!!!!!!!
THANKS!! FOR LOOKING!!!!!!!!!!!!!!!!