Posted to microsoft.public.excel.programming
|
|
vb for nested if with more than 7 statements
Take a look at this:
http://www.contextures.com/xlFunctions02.html
If you feel brave look he
http://www.mvps.org/dmcritchie/excel/vlookup.htm
Regards,
Ryan---
--
RyGuy
"Stuart Bray" wrote:
Use a vlookup instead of an if.
Put your list of cars and prices on another sheet. Then, in the cell
that needs to change - type:
=vlookup(
You can then use the fx button to guide you through using vlookups.
|