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)
Bahot bahot shukriya apka sir jo aap ne itne sare excel sheet provide kraye👍🌺🌺🌺
Welcome Romit Ji