• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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
Tackle projects and never again get stuck behind a technical roadblock.
Join Now