How to Calculate Petrol Conveyance with Formula in Excel Easily

Pricing Chart & Calculation of Petrol Conveyance with Formula in Excel

PETROL CONVEYANCE CALCULATION CHART WITH FORMULAFormula 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

Leave a Comment