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)
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
Share via:
WhatsApp
Facebook
Twitter
LinkedIn
Reddit
Email
2 thoughts on “How to Calculate Petrol Conveyance with Formula in Excel Easily”
Bahot bahot shukriya apka sir jo aap ne itne sare excel sheet provide kraye👍🌺🌺🌺
Bahot bahot shukriya apka sir jo aap ne itne sare excel sheet provide kraye👍🌺🌺🌺
Welcome Romit Ji