Aaditya Hamine
Member
Hi All !
i am working on a requirement put forward by one of my friend who has to do manual entries in excel for booking the invoices . Its basically a courier company which has billing pattern as follows.
There are several filter categories according to which billing is done . These categories can be classified as follows.
1. First he needs to See whether Parcel is for Local delivery( Within state) or Out of state delivery.
2. If its local , then if it is a "document" type or "Non-document ( heavy parcels)"
3. Now consider my docket is "local" and is a "document"
4. Now there are weight slabs starting from 0 to 5Kgs , with each slab of 250gms
5. Billing is done as per the following three main parameters - Local / outbound , Doc/non-doc , Weight slab
I am attaching a file herewith where i have written some basic login using "IF" ( too lengthy though) . Please help me to overcome this problem.
it will be really great if you can send logic in Excel as i am not familier with Macros.
Await your reply.
Thanks ,
Aadi
i am working on a requirement put forward by one of my friend who has to do manual entries in excel for booking the invoices . Its basically a courier company which has billing pattern as follows.
There are several filter categories according to which billing is done . These categories can be classified as follows.
1. First he needs to See whether Parcel is for Local delivery( Within state) or Out of state delivery.
2. If its local , then if it is a "document" type or "Non-document ( heavy parcels)"
3. Now consider my docket is "local" and is a "document"
4. Now there are weight slabs starting from 0 to 5Kgs , with each slab of 250gms
5. Billing is done as per the following three main parameters - Local / outbound , Doc/non-doc , Weight slab
I am attaching a file herewith where i have written some basic login using "IF" ( too lengthy though) . Please help me to overcome this problem.
it will be really great if you can send logic in Excel as i am not familier with Macros.
Await your reply.
Thanks ,
Aadi