Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
some help please.
i reached to the following : =CHOOSE(MATCH("X";F7;0);5) which means if cell f7 has x give me exactly 5 =CHOOSE(MATCH("y";F8;0);6) which means if cell f8 has y give me exactly 6 MY QUESTION NOW.....IS IT POSSIBLE TO COMBINE THOSE TWO FORMULAS IN JUST ONE ??? . ( I WANT IT SIMILAR TO [ IF(AND( ] FUNCTION ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
helpp | Excel Discussion (Misc queries) |