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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com