Hi,
I need help with the formula for cell C1
the scenario is
If A1 is <60 then reduced B1 date to 10weeks
IF A1 IS =60 Then reduced B1 date to 6weeks
Thanks in advance!
goya
Hi,
I need help with the formula for cell C1
the scenario is
If A1 is <60 then reduced B1 date to 10weeks
IF A1 IS =60 Then reduced B1 date to 6weeks
Thanks in advance!
goya
Like that?Please Login or Register to view this content.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
deleted comment
Last edited by dosydos; 12-10-2015 at 03:06 PM. Reason: answer already posted
Hello,
Below is the data and I want the result in the last column.
TYPE LE DATES LE DATE TO FP
MD60 22-Jun-15 4-Jan-15
MD30 22-Jun-15 7-Dec-14
Thanks,
anabelle
Hi,
What I'm trying to get is to have a date on cell C1 depends on the data available on A1 and B1.
for example:
if A1 is =MD60 and B1=22/Jun/2015 then C2 should be 4/Jan/2015 (which is 6 weeks before the date on B1)
if A1 is =MD30 and B1=22/Jun/2015 then C2 should be 7/Dec/2014 (which is 10 weeks before the date on B1)
Thanks in advance,
goya
Assuming 1 Week has 7 days, and column B is in Date format.
=if(A1="MD60",B1-7*6,if(A1="MD30",B1-7*10,""),"")
Hi,
It did not work...it says I've entered too many arguments.
What is A1 is just 60 & 30 not MD60 and MD30.
thanks,
anabelle
try this out.
If you are using MD60 and MD30 then this equationwill work.Formula:Please Login or Register to view this content.
Last edited by dosydos; 12-10-2015 at 03:45 PM. Reason: becoming more descriptive for FDibbins
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
It's now working... thank you so much to all of you the help.
FDibbins...my bad I've entered the wrong cell your formula is good.
dosydos...thanks your is good too.
Glad we got you where you wanted to be
FDibbins taking credit for my work again
Just kidding, glad we could help Goya
oh sorry...you all help me. Thanks :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks