How to Calculate Petrol Conveyance with Formula in Excel Easily
Pricing Chart & Calculation of Petrol Conveyance with Formula in Excel Formula for Pricing: =IF(C3>1000,1.4,IF(C3>350,1.5,IF(C3>240,1.75,IF(C3>120,1.95,IF(C3>0,2.75,))))) Formula for Amount: =IF(C3>1000,1.4*C3,IF(C3>350,1.5*C3,IF(C3>240,1.75*C3,IF(C3>120,1.95*C3,IF(C3>0,2.75*C3,))))) Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project Files