VLOOKUP & Apply Formula

[Literae]

Bonjour,

I have a spreadsheet at the moment for pricing up jobs for different contracts. Each contract has its own mark up.

I was wondering if there was a formula I could put into 1 cell (and then used for the rest of the column) so it could simplify the process.

For example, if A1 contains (TEXT 1), apply formula/calculation (D1*0.9)+(D1*0.9*1.2*0.045) to the Cell.

A1 = Contract
D1 = Retail Price

I would like to put this new formula into B1.

Not sure if it would make this easier, but I would like B1 to contain multiple arguements and find a range of contracts I have in the drop downs in Column A. Not sure if it would be a VLOOKUP table of results or?

TL:DR - I would like B1 to work out the Mark Up of D1, based on A1s contract. For this particular contract A1 (TEXT 1) uses the formula stated above.

Thanks in advance

 

[Literae]

Closest I have so far is:

=IF(ISNUMBER(SEARCH("BSM FORD",A14)),(D14*0.9)+(D14*0.9*1.2*0.045),"")

However I would like to apply multiple arguements and outcomes? For example replacing "BSM FORD" with "VAUXHALL" and apply =D14-(D14/10)

 

[Special-K99]

You dont need brackets round the multiplication

The formula can be simplified to D1*0.9972