Solved

tricky if formula

Posted on 2014-03-25
7
111 Views
Last Modified: 2014-03-25
Hi experts excel 2007

Need a if formula to do the following..

If a2 has the txt complete then b2 equals todsys date format 01/02/2014 if a2 does not have the txt complete then d2.
0
Comment
Question by:route217
7 Comments
 
LVL 8

Expert Comment

by:itjockey
Comment Utility
txt complete

what do u mean by this?
0
 

Author Comment

by:route217
Comment Utility
The word complete. .in cell
0
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 500 total points
Comment Utility
try

=IF(A2="Complete",TEXT(TODAY(),"dd/mm/yyyy"),D2)
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:route217
Comment Utility
Hi gupta

Thanks for the formula but I am getting date as 00/01/1900. .
0
 
LVL 8

Expert Comment

by:itjockey
Comment Utility
I guess I am late in reply... :)  enjoy
0
 

Author Comment

by:route217
Comment Utility
My fault. .fixed
0
 
LVL 20

Expert Comment

by:clarkscott
Comment Utility
format column B as date  (mm/dd/yyyy)

In column B:

=if(A2 = "COMPLETE", Now(), D2)

??

Scott C
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now