View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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.