Hi guys i have a sheet where I every month i calculate the costs for logistics, there are 3 conditions (KM, Weight in KG, and Volumes), where i have to calculate depending on the data put in the columns B,C,D
if it is zone 1,2,3 and has the volumes or weight under those limits it puts those values. if zone 4 and under those 3 limits we have to multiply the value in the table with the extra km in column D. Until now i only had 2 transport company´s so I used if formulas to calculate the costs, but now I have 3 more, a total of 5, and I think if i use if formulas it will be heavy on the code and generate errors. What do you recommend? Thank you very much in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
transaa.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
