erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
Hi, Boardmoderators or other clever people!
In the thread http://www.mrexcel.com/board2/viewtopic.php?p=641200#641200<> sings are deleted from our posts. What should we do to avoid this?
kind regards,
Erik
PS: as you can see there are no chunks here , although at the moment I'm editing this post, they are clearly visible for my eyes
(going to testforum)
=IF(AND(A1<B2,A1>B3),F1,IF(AND(A1<C2,A1>C3),F2,IF(AND(A1<D2,A1>D3),A3,"no match")))
In the thread http://www.mrexcel.com/board2/viewtopic.php?p=641200#641200<> sings are deleted from our posts. What should we do to avoid this?
kind regards,
Erik
PS: as you can see there are no chunks here , although at the moment I'm editing this post, they are clearly visible for my eyes
(going to testforum)
=IF(AND(A1<B2,A1>B3),F1,IF(AND(A1<C2,A1>C3),F2,IF(AND(A1<D2,A1>D3),A3,"no match")))
Map1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 13 | F1 | ||||||
2 | 12 | 14 | 16 | F2 | ||||
3 | F2 | 10 | 11 | 12 | F3 | |||
Blad1 |