|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 25th, 2010, 09:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - more than seven arguments
Good morning
I would like to write an if formula that will provide me with the month (in words) if the date in a column falls between certain values, this needs to be ongoing as the spreadsheet concerned will report ongoing data therefore there will be more than seven sets of criteria to be evaluated. Please could you let me know if this is possible? Many thanks 
|
|
#2
March 25th, 2010, 09:05 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - more than seven arguments
With date in cell A1 try
=TEXT(A1,"mmmm") =TEXT(A1,"mmm") -- Jacob "Hannah" wrote: Good morning I would like to write an if formula that will provide me with the month (in words) if the date in a column falls between certain values, this needs to be ongoing as the spreadsheet concerned will report ongoing data therefore there will be more than seven sets of criteria to be evaluated. Please could you let me know if this is possible? Many thanks
|
|
#3
March 25th, 2010, 09:21 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - more than seven arguments
Brilliant - thank you!
"Jacob Skaria" wrote: With date in cell A1 try =TEXT(A1,"mmmm") =TEXT(A1,"mmm") -- Jacob "Hannah" wrote: Good morning I would like to write an if formula that will provide me with the month (in words) if the date in a column falls between certain values, this needs to be ongoing as the spreadsheet concerned will report ongoing data therefore there will be more than seven sets of criteria to be evaluated. Please could you let me know if this is possible? Many thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
