Excel IF/Lookup

[r***@gmail.com]

Hi

I am quite new to all of this I have done simple IF statements and
formula's. For my HND assignment I have a problem whereby I need to
create a spreadsheet to calculate a discount. The next part of the
task is to do it by VBA but for the first part I need to use a
spreadsheet.

I have customer types Individual, School, Library & Educational
Institute. The quantity of books the customer buys (in addition to
the type of customer) dictates what discount is applied.

My issues are mainly because it takes 2 factors but also the breakdown
of number of books for individual is different to that of the other
customer type.

I was originally thinking of something like IF cust type = x and no of
books is less than 5, x. However then I need to do that for all 4
customer types and each number breakdown but also I would neeed to put
a false valuein the statement.

I have tried creating tables and naming them but I am unsure of how to
create LOOKUP or VLOOKUP functions.

Does anyone have any suggestions

Thanks

Rache

[Michael J Davis]

Post by r***@gmail.com
Hi
I am quite new to all of this I have done simple IF statements and
formula's. For my HND assignment I have a problem whereby I need to
create a spreadsheet to calculate a discount. The next part of the
task is to do it by VBA but for the first part I need to use a
spreadsheet.
I have customer types Individual, School, Library & Educational
Institute. The quantity of books the customer buys (in addition to
the type of customer) dictates what discount is applied.
My issues are mainly because it takes 2 factors but also the breakdown
of number of books for individual is different to that of the other
customer type.
I was originally thinking of something like IF cust type = x and no of
books is less than 5, x. However then I need to do that for all 4
customer types and each number breakdown but also I would neeed to put
a false valuein the statement.
I have tried creating tables and naming them but I am unsure of how to
create LOOKUP or VLOOKUP functions.
Does anyone have any suggestions

Frankly have you tried Help ?

I'm not being facetious, but the program contains some useful stuff.

Alternatively click on fx and enter Vlookup and it will enable you to
play with sample figures and see what happens.

Mike

[The reply-to address is valid for 30 days from this posting]