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:
• 2
1 Solution

Commented:
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

Commented:
Sorry, missing comma, should be like this.....

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

regards, barry
0

Commented:
``````=IF(A2="",B2,A2)
``````
0

Commented:
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
``````
, 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.

Featured Post

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