Formula with Conditions

[kmpmba]

Require urgent assistance - Please assist with the required formula - TIA

FILE 1
Property	D
Length	500
Breath	200
Type	A
Requirement Nos.	(cell B6 - Answer required here)
Rules to Calculate answer in B6
Multiply Length (B3) with Breath (B4)
Divide by area (available in File 2)
IF Property = D - Double the total at this stage
Add 10% to Total
Add 50 Nos. to Total
FILE 2
TYPE	Area
A	139.75
B	156.95
C	163.67

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Finalfight40]

Im assuming File 2 is the name of sheet 2? And also the values in file 2 are in B2, B3 AND B4?

something like this?

=IF(B2="D", ((B3*B4)/INDEX('FILE 2'!B2:B4, MATCH('FILE 1'!B5, 'FILE 2'!A2:A4)))*2*1.1+50, ((B3*B4)/INDEX('FILE 2'!B2:B4, MATCH('FILE 1'!B5, 'FILE 2'!A2:A4)))*1.1+50)

 

[kmpmba]

Im assuming File 2 is the name of sheet 2? And also the values in file 2 are in B2, B3 AND B4?

something like this?

=IF(B2="D", ((B3*B4)/INDEX('FILE 2'!B2:B4, MATCH('FILE 1'!B5, 'FILE 2'!A2:A4)))*2*1.1+50, ((B3*B4)/INDEX('FILE 2'!B2:B4, MATCH('FILE 1'!B5, 'FILE 2'!A2:A4)))*1.1+50)

Mant thanks - used this instead =(B3*B4/VLOOKUP(B5,A18:B20,2,0)*IF(B2="D",2,1))*1.1+50