ThatLibraryMiss
New member
- Joined
- Nov 5, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I'd really appreciate some help with this, please.
I'm trying to put a value into a target cell. It looks at two other cells to decide what value should be there. There are three possible values, D, M and E.
Put D in the target cell if any of these conditions are true:
H3=2 and N3<3
H3=3 and N3<6
H3=4 and N3<9
H3=5 and N3<12
H3=6 and N3<15
Put M in the target cell if any of these conditions are true:
H3=2 and N3<4
H3=3 and N3<7
H3=4 and N3<10
H3=5 and N3<13
H3=6 and N3<16
Put E in the target cell if any of these conditions are true:
H3=2 and N3<5
H3=3 and N3<8
H3=4 and N3<11
H3=5 and N3<14
H3=6 and N3<17
I am completely stumped with this one. I can get it to put D in the cell if H3=5 and N3 < 12 using =IF(AND(H3=5,N3<12),"D"). I tried using OR to add more conditions and it just falls over.
I'm trying to put a value into a target cell. It looks at two other cells to decide what value should be there. There are three possible values, D, M and E.
Put D in the target cell if any of these conditions are true:
H3=2 and N3<3
H3=3 and N3<6
H3=4 and N3<9
H3=5 and N3<12
H3=6 and N3<15
Put M in the target cell if any of these conditions are true:
H3=2 and N3<4
H3=3 and N3<7
H3=4 and N3<10
H3=5 and N3<13
H3=6 and N3<16
Put E in the target cell if any of these conditions are true:
H3=2 and N3<5
H3=3 and N3<8
H3=4 and N3<11
H3=5 and N3<14
H3=6 and N3<17
I am completely stumped with this one. I can get it to put D in the cell if H3=5 and N3 < 12 using =IF(AND(H3=5,N3<12),"D"). I tried using OR to add more conditions and it just falls over.