about variable.

[#1]

now I have tables.

among that, one is composed product, price.

                    (calculated values)

A     100               ?

B     200               ?

C     300               ?

so i wanna receive a variable(vSer) on Input box.

(maybe vSer will be 1~10 number.)

After received value, go to calculation.

ex.vSer is "4".

100*v.Ser=400

<result>

using three charts(

1. product, price

2. input box(variable)

3. result (product name, 400)

I need three variables(for A, B and C)

and hope to calculate separate values.

now Im using this in result (one expression of listbox)

if(vSer1 > 0, vSer1*price), price)

if(vSer2 > 0, vSer2*price), price)

....I know thats innocence.

Final Result I want

(variable input box)          (result box)

A     4                                   A     400

B     2                                   B     400

C     9                                   C     2700

* I hope checking many products at same time.

thankyou

[#2]

Might be something like attached.

Hope it helps!

[#3]

thank you, Shyamal Pandit.

but, I want to write values each other differently

like above

ex)

A 4

B 2

C 7

in three variable block of one input box.

thank you

[#4 · Accepted solution]

ok, PFA.

I have achieved it using if, I think better can be done using set analysis, but I am not very sure about that.

[#5]

thank you!!!!!!!

I solved it FINALLY!!

now I can solve left 20 products..

thank you again!!