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

Join Our Telegram Group techguruplus telegram group
Join Our Whatsapp Group techguruplus whatsapp group

Group 1  |   Group 2

 

2 thoughts on “How to Calculate Petrol Conveyance with Formula in Excel Easily”

Leave a Comment