Button Description Listing
Input Keypads
Backspace input characters
There is a keypad for each input box. Both keypads are identical with ten numeric keys, a decimal [point] key and a key marked 'CL' which clears the relevant input box.
The string of digits in the input box is added to by each keypress on the keypad. If numbers are already in the input box, the keypad will add digits to the right.
The cursor does not need to be in the relevant input box for the keypad to work, and the cursor is not moved after the keypad is used, except for the CL key which clears the input box
and puts the cursor in the box.
The decimal button adds a decimal point to the right hand end of the string of existing digits. If more than one decimal point is entered the value will default to zero.
Digits can be entered directly from the PC keyboard if the cursor is in the input box. If non–numeric characters are entered, the value will default to zero, when the cursor leaves the input box.
The backspace button erases the last digit showing in the adjacent Input box. Characters can be erased by clicking in the Input box and using the keyboard backspace or delete keys.
Back to Menu
Memory functions
Memory functions work like classic calculator memories. There is one memory associated with each input. To clear a memory use the M1Ca or M2Ca button. M1Sa and M2Sa save the current value
of input #1 or #2 to the relevant memory, replacing the current value of the memory. M1+/M2+ and M1–/M2– add or subtract the input value from the existing memory value.
The memory value can be sign–changed with the adjacent +/– button.
The value in the two memories can be exchanged with the 'Mem 1 <> Mem 2' button.
The memory values can be exported directly to the result box using the To Result box from: memory move buttons M1 and M2, (just below the result box).
In reverse, the result of calculations can be added to/subtracted from either memory, using the four M1+, M1–, M2+, M2– buttons in the From Result box to: group of buttons.
In–Cell saves the values in the two memories when you exit the calculator (don't forget to close In–Cell before quitting Excel), and the results will be there next time you start In–Cell. Values are stored by User, if separate user log–on profiles have been setup in Windows.
Back to Menu
Sign change
The sign of both data inputs, both memories and the result can be reversed using the sign change button next to the appropriate value box.
Back to Menu
Decimal / Integer / Whole number rotation
If the number in the adjacent input box has both an integer part and a decimal (fractional) part, then this button will rotate
through the two components (integer and decimal) and then back to the whole number.
This button can also be used to reverse decimal rounding,
as it will return the value in the input box to the value before rounding was applied.
Back to Menu
Decimal Rounding
The decimal part of the value in the adjacent input box can be rounded. Each click of this button reduces the number of decimal places used, rounding the result at each step.
It appears that the VBA rounding function uses 'Bankers' rounding rather than normal mathematical rounding. In this blog about rounding
the bankers rounding is described as follows: The convention is to round to the nearest even number, so that both 1.5 and 2.5 round to 2, and 3.5 and 4.5 both round to 4.
In–Cell makes a small adjustment to the value before rounding to approximate to mathematical rounding, rather than bankers rounding
The adjustment added is 0.000000001
The Round function does not currently round the integer part of the number, i.e., rounding stops when there are no decimal places remaining.
To reverse rounding, use the D/I button – See Decimal / Integer / Whole number function.
Back to Menu
Sum of Range
If a range of cells has been selected, the sum of all the cells containing numbers is placed in the adjacent input box.
Note that this function does not use, or change, In–Cell's Active Cell.
Back to Menu
Copy from Active Cell
The Copy button copies the value in In–Cell's Active Cell, into the adjacent input box, replacing the current contents.
In–Cell's Active Cell is the cell outlined in red or other user–selected colour, not the cell selected in Excel, although they are often the same cell.
Back to Menu
Standard operators
This group of buttons provide the standard multiply, divide, add and subtract functions.
The function selected is shown in the adjacent operator box. No action occurs until the equals button is hit.
If equals is hit, but no operator has been selected, a warning box opens, and no operation is performed (i.e., there is no default operator),
however, once an operator has been selected, it will be used until changed. The operator selected can always be seen in the adjacent operator box.
Back to Menu
Equals Operator
The equals button carries out the calculation selected by the standard operators. Note that percentage functions are not dependant on the equals sign.
The adjacent current function box displays the equals signs or one of the percentage functions.
Back to Menu
Current Function Display
The selected operator, Equals, Percentage, As percentage or Plus/minus percentage is displayed in this box. This displays the last calculation undertaken, although if Equals is shown, then the current operator box shows the specific function, (x, /, + or – ).
Back to Menu
Percentage Function
The Percentage function performs a simple percentage calculation. The result is Input 2's percentage of Input 1.
Example: Input #1 = 200, Input #2 = 8, Result = 16. The current operator box shows '%'.
Back to Menu
As Percentage Function
The As percentage function calculates what percentage Input 2 is, of Input 1.
Example 1: Input # 1 = 200, Input #2 = 8, Result = 2500.
Example 2: Input # 1 = 8, Input #2 = 200, Result = 4. (i.e., eight is 4% of 200). The current operator box shows 'A%'.
Back to Menu
Plus or Minus Percentage
The Plus or minus percentage function adds or subtracts Input 2's percentage of Input 1 to the value of Input 1.
Example 1: Plus percentage: Input # 1 = 200, Input #2 = 8, Result = 216. The current operator box shows '+%
Example 2: Minus Percentage: Input # 1 = 200, Input #2 = 8, Result = 184. The current operator box shows '–%'.
Back to Menu
Move Results to Other Locations
These buttons move the value in the Result box to other locations: Inp 1 to Input #1, Inp 2 to Input #2, and CB to the Windows clipboard. The value can be added to or subtracted from either memory using one of the four memory buttons, (M1+, M1–, M2+ and M2–).
Back to Menu
Paste Result to Active Cell
Undo Paste
The Paste Value button pastes the value in the Result box to the Active Cell, (In–Cell's highlighted Active Cell).
The Undo Paste button reverses the last Paste Value or Paste Formula action. The previous cell contents are replaced.
Note that this is a single undo function – ONLY the last paste function is reversed. Only one value is held in the Undo function. This may be changed in a future release.
Back to Menu
Section Hide or Display Bar
The bars above the three exchange function buttons and above the three special conversion / extraction groups can be clicked to hide the relevant button group.
Clicking the bars when the section is hidden redisplays the group of buttons. These options allow the space taken up by In–Cell on the screen to be reduced when these functions are not needed.
Note also that In–Cell can be minimized using the minimize button at top–right of the calculator. The minimized display stays within Excel's boundaries, in the bottom–left corner.
Click the Restore Up button to redisplay In–Cell.
Back to Menu