Conditional display based on another cell
Posted by Eric on December 17, 2001 9:10 PM
I would like to have one cell with some letters
Then I would like to have the cell next to it display a number 4 for the letters D2 and only those letters. But if there was a D1 there instead I would like a 6 in the next cell. Or if there was a D2C/N1 I would like an 8, and so on. Not necessarily continuing on in that order.
So I have my own list of predefined texts with corresponding numbers associated with them (which are actually in hours) and I would like to be able to have a formula that will display the hours I want when the cell before it has the appropriate Text (I would like it to be case insensitive but it is not necessary). Any help is greatly appreciated.
I could do this in C but I wouldnt know how to put it in and I dont know VBA. Thanks in advance.