# Difficult Equation

#### sinb000

##### New Member
I need to set an equation , but i dont know how do i start with it.

I have a table of Nationalities with almost 25 Nationality and tickets fare (2 Columns and 25 Rows)
I have also Status of the tickts in the contract
-One Basic Salary-Cash
- Yearly Ticket up to one Basic Salary
- Tickts after 2 Years
- Tickts after 3 Years
- No tickets entitled

I have the inputs;
- Employees data which takes the salary and all employees data
- a table which gives the Nationality and Tickt fare

Now , if i use IF function it wont fit coz the max equation is almost 40-46 equations, also tried to use index and match but i'm not sure that it will works coz this function needs tables
kindly assist
-

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### Smitty

##### Legend
Can you post an example of what you've got now and your desired output? Check my sig for how to post a shot of your sheet.

#### sinb000

##### New Member
Dear Smitty ,
I dont have a table to put , the data that I have is shattered

the contract status is in the employees data
the Ticket rates according to Nationality is another table in other sheet

what I exactly need
I need to put a cell in the employees data where it can figure the ticket fare directly after it sees the Nationality and contract status
I already made this with IF function but the problem is i have 25 Nationality where IF function will not accept

coz with IF function each Nationality will see the 5 contact status;
-One Basic Salary-Cash
- Yearly Ticket up to one Basic Salary
- Tickts after 2 Years
- Tickts after 3 Years
- No tickets entitled

so I should make total of 125 IF Function which cant be

Replies
4
Views
116
Replies
26
Views
1K
Replies
10
Views
437
Replies
4
Views
70
Replies
0
Views
22

1,109,349
Messages
5,528,188
Members
409,807
Latest member
nicky736

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
• Auto-Create a monthly Sign in sheet for preschool students
The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
• VBA vlookup multiple results
Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
• Extract values for earliest/latest times
I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...