Hi,
I've almost figured out how to do what I want but I was hoping someone could give me a hand.
I've created a two buttons that when pressed add together and minus from another cell. M23 Cell (TOOL LENGTH W EXT) displays a negative number before the button is pressed. I would like this cell to read nothing until this operation of button pressing is performed. I have a IF statement that is giving me the negative number before the button operation is performed "=IF(M22<M21,M22-M21,M22-M21)". Not sure if there is something else i can use to rectify that ? Is there any way to display on the Excel Sheet how many times (.76)or(1.37) button was pressed to arrive at the solution ?
Capture.PNG
Bookmarks