Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vb for nested if with more than 7 statements
Hi,
I have a nested if with 9 statements, which won't work. I've looked this up and read i need to convert to code. Can i please have some help? I know VB for access, but not really done much with excel. I have 9 different car types, and each one has a different value. I just want it to say, after a cell in range B2:B1000 is changed, if that cell = car type 1, the cell in C2:C2000 changes to the value £100 and if it changes to car type 2, the cell in column C changes to value £200 etc..... Thanks, Kirstie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested If Statements | Excel Worksheet Functions | |||
Too Many Nested IF Statements! | Excel Worksheet Functions | |||
Help with nested if/or statements | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
Nested IF statements | Excel Discussion (Misc queries) |