Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

I need to update an excel formula

I am using the following formula:

=IF(I10="","",TEXT(I10,"M/D/YY")&" (E)")

I need to be able to also check another cell for a date value, AO10. If there is a value there it returns the value, adds a space, and then (A). If there isnt a value, it just goes through the original formula.

Ideally, it would look like this with both having values:

3/1/12 (E)
3/5/12 (A)

Value in I10 and no value AO10:

3/1/12 (E)

Value in AO10 and no value in I10:

3/5/12 (A)
0
wrt1mea
Asked:
wrt1mea
  • 2
  • 2
2 Solutions
 
nutschCommented:
Something like this? Can you have a case when both AO10 and I10 have a value?

=IF(I10="",TEXT(AO10,"M/D/YY")&" (A)",TEXT(I10,"M/D/YY")&" (E)")

or something like that, with a line feed in between?

=IF(I10="","",TEXT(I10,"M/D/YY")&" (E)") & char(10) & if(AO10="","",TEXT(AO10,"M/D/YY")&" (A)")


Thomas
0
 
wrt1meaAuthor Commented:
Yes, I can have mult cases where both cells have values...
0
 
nutschCommented:
Then use this formula, with the cell formatted as wrap text:


=IF(I10="","",TEXT(I10,"M/D/YY")&" (E)") & char(10) & if(AO10="","",TEXT(AO10,"M/D/YY")&" (A)")
0
 
Naresh PatelTraderCommented:
if I properly understood your question "you are searching date values in both cell with combination then try this. this formula searching for only date values.
=IF(AND(CELL("Format",I10)="D4",AO10=""),TEXT(I10,"M/D/YY")&" (E)",IF(AND(CELL("Format",AO10)="D4",I10=""),TEXT(AO10,"M/D/YY")&" (A)",IF(AND(CELL("Format",I10)="D4",CELL("Format",AO10)="D4"),TEXT(I10,"M/D/YY")&" (E)"&"   "&TEXT(AO10,"M/D/YY")&" (A)",IF(AND(I10="",AO10=""),""))))

Open in new window


thanks
0
 
wrt1meaAuthor Commented:
THANKS! WORKS GREAT!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now