| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
In each line of column A of spread sheet is day of the month in format
ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday and H for Holiday. I tried with nasted IF and it works except for the Holiday. Please assume month of December with Holidays at 1st December, 8th December and 25th of December. Thanks for help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
2ª
What is that superscript character after the number? With my poor eyesight, it looks like a lowercase "a". What does that mean? -- Biff Microsoft Excel MVP "henriques" wrote in message ... In each line of column A of spread sheet is day of the month in format ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday and H for Holiday. I tried with nasted IF and it works except for the Holiday. Please assume month of December with Holidays at 1st December, 8th December and 25th of December. Thanks for help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
Biff,
it returns a CODE of 170, and does look like lower case a when copied into Excel (and zoomed). Pete On Dec 18, 11:21*pm, "T. Valko" wrote: 2ª What is that superscript character after the number? With my poor eyesight, it looks like a lowercase "a". What does that mean? -- Biff Microsoft Excel MVP "henriques" wrote in message ... In each line of column A of spread sheet is day of the month in format ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday and H for Holiday. I tried with nasted IF and it works except for the Holiday. Please assume month of December with Holidays at 1st December, 8th December and 25th of December. Thanks for help- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
It's a caracter used in Portugal to shorten some words like week days. We use
as well caracter º for ordinal numbers, first we write 1º. But forget the caracter and use the normal "a" Thanks "T. Valko" wrote: 2ª What is that superscript character after the number? With my poor eyesight, it looks like a lowercase "a". What does that mean? -- Biff Microsoft Excel MVP "henriques" wrote in message ... In each line of column A of spread sheet is day of the month in format ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday and H for Holiday. I tried with nasted IF and it works except for the Holiday. Please assume month of December with Holidays at 1st December, 8th December and 25th of December. Thanks for help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
I tried with nasted IF and it works except for the Holiday.
OK, if you have something that works up to that point then you just need to add to it. List the holiday dates in a range of cells. J1 = 12/1/2008 J2 = 12/8/2008 J3 = 12/25/2008 Assuming your dates for the month start in cell A1. Then add this to the *beginning* of your current formula: =IF(COUNTIF(J$1:J$3,A1),"H", -- Biff Microsoft Excel MVP "henriques" wrote in message ... It's a caracter used in Portugal to shorten some words like week days. We use as well caracter º for ordinal numbers, first we write 1º. But forget the caracter and use the normal "a" Thanks "T. Valko" wrote: 2ª What is that superscript character after the number? With my poor eyesight, it looks like a lowercase "a". What does that mean? -- Biff Microsoft Excel MVP "henriques" wrote in message ... In each line of column A of spread sheet is day of the month in format ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday and H for Holiday. I tried with nasted IF and it works except for the Holiday. Please assume month of December with Holidays at 1st December, 8th December and 25th of December. Thanks for help |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
Thanks Walco, it works onderfull
"T. Valko" wrote: I tried with nasted IF and it works except for the Holiday. OK, if you have something that works up to that point then you just need to add to it. List the holiday dates in a range of cells. J1 = 12/1/2008 J2 = 12/8/2008 J3 = 12/25/2008 Assuming your dates for the month start in cell A1. Then add this to the *beginning* of your current formula: =IF(COUNTIF(J$1:J$3,A1),"H", -- Biff Microsoft Excel MVP "henriques" wrote in message ... It's a caracter used in Portugal to shorten some words like week days. We use as well caracter º for ordinal numbers, first we write 1º. But forget the caracter and use the normal "a" Thanks "T. Valko" wrote: 2ª What is that superscript character after the number? With my poor eyesight, it looks like a lowercase "a". What does that mean? -- Biff Microsoft Excel MVP "henriques" wrote in message ... In each line of column A of spread sheet is day of the month in format ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday and H for Holiday. I tried with nasted IF and it works except for the Holiday. Please assume month of December with Holidays at 1st December, 8th December and 25th of December. Thanks for help |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "henriques" wrote in message ... Thanks Walco, it works onderfull "T. Valko" wrote: I tried with nasted IF and it works except for the Holiday. OK, if you have something that works up to that point then you just need to add to it. List the holiday dates in a range of cells. J1 = 12/1/2008 J2 = 12/8/2008 J3 = 12/25/2008 Assuming your dates for the month start in cell A1. Then add this to the *beginning* of your current formula: =IF(COUNTIF(J$1:J$3,A1),"H", -- Biff Microsoft Excel MVP "henriques" wrote in message ... It's a caracter used in Portugal to shorten some words like week days. We use as well caracter º for ordinal numbers, first we write 1º. But forget the caracter and use the normal "a" Thanks "T. Valko" wrote: 2ª What is that superscript character after the number? With my poor eyesight, it looks like a lowercase "a". What does that mean? -- Biff Microsoft Excel MVP "henriques" wrote in message ... In each line of column A of spread sheet is day of the month in format ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday, 4ª for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for Sunday and H for Holiday. I tried with nasted IF and it works except for the Holiday. Please assume month of December with Holidays at 1st December, 8th December and 25th of December. Thanks for help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
