I have a table as follows in a 2nd worksheet
4 License
8 License
16 License
32 License
64 License
128 License
In the main worksheet I have Cell B2 as List that allows you to choose 4-128 no problem
Cell B1 is the number of computers
IF B1 <= 4 B2 would display all options
Now the tricky part:
IF B1 =>5 I would like to have only 8 thru 128 available to display
IF B1 =>9 then only 16 thru 128 display
etc, etc
I have been playing with nested IF Statements but not sure if this is the correct way or my syntax is off.
Thanks
Bookmarks