| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To detect month or days or year in if formula
Hi fren,
Can anybody show me how to detect particular month in if formula. E.g is in A1 cell the data is 01/10/2006. The formula that I want to do is if the month in cell A1 is '10', then B18*2 . Ok thanks fren. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To detect month or days or year in if formula
=IF(MONTH(A1)=10,B18*2,"")
-- David Biddulph "ShamsulZ" wrote in message ... Hi fren, Can anybody show me how to detect particular month in if formula. E.g is in A1 cell the data is 01/10/2006. The formula that I want to do is if the month in cell A1 is '10', then B18*2 . Ok thanks fren. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter variable data into a formula | Excel Discussion (Misc queries) | |||
| need help with formula | Excel Discussion (Misc queries) | |||
| Vacation Accrual Formula | Excel Worksheet Functions | |||
| Formula for # of sales days in a month? | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Linear Mode
