Formulas

JoeShed

New member
Joined
Aug 1, 2016
Messages
1
Reaction score
0
Points
0
Hi there,

I am trying to create a formula for the following:

A car a particular model (out of 13) on the top row, it is also a number of years old down the side of the table, in order to work out the margin to add on I should charge the value by the value where the two fields meet.

I have to do this process 300 times manually, so a formula is a must have!

Ford
VW
Seat
Jaguar
Nissan
Audi
BMW
Toyota
Izuzu
Merc
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,767
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Hi
please post a sample sheet showing your data and expected results. Thx
 

SUNNY KOW

New member
Joined
Jul 24, 2016
Messages
41
Reaction score
0
Points
0
Location
Malaysia
Hi JoeShed

Is this what you are looking for?
 

Attachments

  • JoeShed.xlsx
    9.4 KB · Views: 16
Top