Variables

[seanbain]

Help please.....I am trying to set up a variable in excel to work in the following way:example : whereby D6 would give the answer dependant on the number inputed into D5 which would be an input number between 0 and 99 The answer would be dependant on the number inputed into D5 i.e input 1 answer =2, input 5 answer =12, input 17 answer =112 etcIf someone could answer this they would be a life saver. Thanks

[Oleg]

The cell D6 contains some expression and calculates the value depending on the value in D5 cell.
You can get this value by using Clipboard Copy action (for example)

i.e. you put into D5 some value, right arrow, Clipboard copy.
Next you can get this value from clipboard and put in into variable (see "Get Text" action in Clipboard group)