STEP by STEP guidance to obtain desired results to be filled out in EXCEL

PROBLEM 1

if in column TYP the value is PL 

than do nothing (keep the cell G1, H1, I1 empty) 

********************************************

PROBLEM 2

if in column TYP the value is PE

than calculate value in "x1 in (m)" 

check condition "F is W" or "F is E" or F is S" 

here the condition is "F is W" so 

fill in default value from "Y in (m)" to "y1 in (mm)" and from "Z in (m)" to "z1 in (m)" 

FORMULA to calculate/obtain value in "x1 in (m)" i.e. 1960.85

from the DIM in (mm) always select the first value before "x" for i.e. 600 

and convert it from millimeter (mm) into meter (m) i.e. 600/1000 = 0.6 

now add the result i.e. "X in (m)" + "0.6"

********************************************

PROBLEM 3

if in column TYP the value is HO

than calculate value in "y1 in (m)" 

check condition "F is W" or "F is E" or F is S" 

here the condition is "F is E" so

fill in default value from "X in (m)" to "x1 in (mm)" and from "Z in (m)" to "z1 in (m)" 

FORMULA to calculate/ obtain value in "y1 in (m)" i.e. 5988.27

from the DIM in (mm) always select the first value before "x" for i.e. 500 

and convert it from millimeter (mm) into meter (m) i.e. 500/1000 = 0.5 

now add the result i.e. "Y in (m)" - " 0.5" 

********************************************