Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customized Formula
I'm in need of a very specific formula please.
A1 to A100 are all different dates as 02/17/08 ( m,d,y) (could also omitt the year) B1 to B100 will be formulas ( of course I just need B1 formula so I copy it down) Something like : if A1=1/2/08 B1 will show "FHFQ" -- Probably it has to show in C1 as B1 has the formula (well, it doesn't matter to me either way). FHFQ means "first half first quarter" of the year of course. So everytime a date is enter in A1 to A100, B or C columns(as you wish) will show the previous text if dates are from 1/1/8 to 2/15/08. If I enter 3/1/08 then it will show "SHFQ" meaning "second half of first quarter". It's very complicated to me because the need of setting a range in the formula and also how the text will appear accordinly to the range the date is in. By the way the year does not matter as is the same for me any year. Just the day and the month. Thanks a lot in advance. Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customized worksheet security | Excel Discussion (Misc queries) | |||
Customized Toolbars | Excel Discussion (Misc queries) | |||
How do you keep your toolbar customized the way you set it up? | New Users to Excel | |||
Excel customized tolbar | Setting up and Configuration of Excel | |||
Customized Formats | Excel Worksheet Functions |