Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make easier to use formula's / have better / useful examples
(got an army of programmers?? got billions, and don't have 2, 3, 4 armies??)
would recommend refining the process. 1 area: would recommend combination of commands in 2 or 3 letter abbreviations, mnemonics.. e.g.: (isnumber(search could be: IS(LEFT(B9,2),$B$2) but would allow inclusive / exclusive properties programmed in such as: =IF(LEN(B9)<2,FALSE,ISNUMBER(SEARCH(LEFT(B9,2),$B$ 2))) resources being what they are. (this does not work anyways, see below) trying to find if LEFT(B9,2): F00 is in $B$2 $B$2: A0 B0 C0 D0 E0 F0 B9: "F" should return a false If LEN<2 used can still get a false result.. .. ok have 3 versions of the formula in the same cell using 3 different comparitor cells containing: $B$2: A0 B0 C0 $B$3: H0 X0 $B$4: .. zero (0) problem would like formula's to work for us, instead of us for them, thanks 10 character functions requiring other functions just to do simple requests taking to many resources. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make easier to use formula's / have better / useful examples
see response to your earlier posting
-- Regards Roger Govier "nastech" wrote in message ... (got an army of programmers?? got billions, and don't have 2, 3, 4 armies??) would recommend refining the process. 1 area: would recommend combination of commands in 2 or 3 letter abbreviations, mnemonics.. e.g.: (isnumber(search could be: IS(LEFT(B9,2),$B$2) but would allow inclusive / exclusive properties programmed in such as: =IF(LEN(B9)<2,FALSE,ISNUMBER(SEARCH(LEFT(B9,2),$B$ 2))) resources being what they are. (this does not work anyways, see below) trying to find if LEFT(B9,2): F00 is in $B$2 $B$2: A0 B0 C0 D0 E0 F0 B9: "F" should return a false If LEN<2 used can still get a false result.. .. ok have 3 versions of the formula in the same cell using 3 different comparitor cells containing: $B$2: A0 B0 C0 $B$3: H0 X0 $B$4: .. zero (0) problem would like formula's to work for us, instead of us for them, thanks 10 character functions requiring other functions just to do simple requests taking to many resources. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel should make it easier to have a 1 to 1 plot area in chart | Charts and Charting in Excel | |||
Please make it easier to access the IS functions (e.g., isblank) . | Excel Worksheet Functions | |||
How do I set up excel to make estimating(pricing) easier? | Excel Discussion (Misc queries) | |||
Need a formula that would make life easier | New Users to Excel | |||
Need a formula that would make life easier | Excel Worksheet Functions |