From: Ashish Dabral <[email-masked]>
To: Mansi Chhabra <[email-masked]>
Date: Tue, 26 Sep 2017 12:57:20 +0530 (IST)

Roomer Price: - =IF(N2="Yes",O2,O2*IF(J2="Yes","40%",IF(K2="Yes","45%",IF(L2="Yes","50%","60%")))) 

Sellable price :- =IF(N2="Yes",O2,O2*IF(J2="Yes","50%",IF(K2="Yes","55%",IF(L2="Yes","60%","70%")))) 

Regards, 
Ashish Dabral