| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make a formula calculating all cells after a certain date
I would like to make a formula if A2 contains a date after Oct 1 2006, then
multiply B2 by 2, how do I do it? Thanks a lot |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a formula calculating all cells after a certain date
Mottyb, here is one way,
=IF(A2DATEVALUE("10/01/2006"),B2*2,"") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mottyb" wrote in message ... I would like to make a formula if A2 contains a date after Oct 1 2006, then multiply B2 by 2, how do I do it? Thanks a lot |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a formula calculating all cells after a certain
Thanks a million it works great. Special thanks for the quick response.
"Paul B" wrote: Mottyb, here is one way, =IF(A2DATEVALUE("10/01/2006"),B2*2,"") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mottyb" wrote in message ... I would like to make a formula if A2 contains a date after Oct 1 2006, then multiply B2 by 2, how do I do it? Thanks a lot |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a formula calculating all cells after a certain
Your welcome
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mottyb" wrote in message ... Thanks a million it works great. Special thanks for the quick response. "Paul B" wrote: Mottyb, here is one way, =IF(A2DATEVALUE("10/01/2006"),B2*2,"") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mottyb" wrote in message ... I would like to make a formula if A2 contains a date after Oct 1 2006, then multiply B2 by 2, how do I do it? Thanks a lot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula for calculating an expiration date? | Excel Worksheet Functions | |||
| FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
| formula for calculating # of days between 2 cells | Excel Worksheet Functions | |||
| Calculating current age from 2 date cells | Excel Worksheet Functions | |||
Linear Mode
