regarding Between option
Hi friends, this is very urgent, plz help me.
I want to write the condition for the below logic.
x value y value
If x is 0-<10 10,000 will be used
If x is 10-<100 1,000 will be used
Thanks and regards
IF x gt 0 and x lt 10.
y = 10,000.
IF x gt 10 and x lt 100.
y = 1,000.