Improve company productivity with a Business Account.Sign Up

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

excel table logical formula

in an excel file I have three fields and need a logical formula to fill one.

FIeld Names:
Release Date
Release Date Est
Release Date Act

if Release Date exists then Release Date Act should = Release Date otherwise Release Date Act = Release Date Est.

How would the logical format look for that?
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
1 Solution
 
barry houdiniCommented:
Assuming that Release date is in A2, Release Date Est in B2 then try this formula in C2

=IF(A2,A2,IF(B2,B2""))

regards, barry
0
 
barry houdiniCommented:
Sorry, missing comma, should be like this.....

=IF(A2,A2,IF(B2,B2,""))

regards, barry
0
 
bitrefCommented:
=IF(A2="",B2,A2)

Open in new window

0
 
NickGermiCommented:
Assuming one of the fields of Release date or Release Date Est is going to be blank, you can use Release Date Act = merged value of Release Date and Release Date Est, in formula it looks like
=A2&B2

Open in new window

, then you can hold the corner of the column and drag you mouse all the way down to fill the rest of the columns with associated updated formula
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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