I am trying to call the value of a variable created with this code:
Dim Materiality As Long
Dim PerfMateriality As Long
Dim SamplingThreshold As Long
Materiality = InputBox("Type in the Materiality for this client (to the nearest €).")
Now I am tryinh to append a field on the spreadsheet that would give me a yes or not as to the transaction is above or below the materiality or the sampling threshold.
In the Equation Editor I am using the following code:
@if( AMOUNT >= &Materiality&, "Yes","No").
I tried to find guideline as to how to call a variable but I did find it anywhere.
Could you please help me?
Last seen: 3 months 1 day ago
Joined: 10/29/2019 - 11:28