inputbox values calculation

[#1]

Hi All

i have data as below

employee_id     salary    age

1                     50            25

2                    60              32

3                    25              25

4                    120          20   

5                    150             45

i need to have 2  inputboxs where if i give a value 100 in Salary input box and  25 in Age input box

it should calculate me the values whose salary is less than 100 and age equal to 25

so my output here is

employee_id     salary    age

1                     50            25

3                    25              25

[vishsaggi]

May be try this?

SalaryInput is your first Inputbox

AgeInput is your Age inputbox.

Using straight table:

Dim: = IF( salary < SalaryInput AND age = AgeInput,  employee_id)

Expr: = Salary

         = Age

[sinanozdemir · Accepted solution]

Hi,

You can use something similar to the attached:

Thanks

[neelamsaroha157]

Is this what you are looking for

[#5]

Hi

Sinan Ozdemir  

neelamsaroha1575                   

Thank you so much your answers solved the problem