# Insert Cell Value based on criteria

#### tjc154

##### Active Member
I want to create a formula in Column X that returns a value of TBD if no date is populated in a Column U. Once a date is populated in column U, TBD will change to a date in column X.

I tried the below formula

=IF(COUNTBLANK(U25)>0,"TBD",=SUM(U25+2)

The date format I'm using is m/dd/yy

Thoughts

Thank you

Tom

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
I want to create a formula in Column X that returns a value of TBD if no date is populated in a Column U. Once a date is populated in column U, TBD will change to a date in column X.

I tried the below formula

=IF(COUNTBLANK(U25)>0,"TBD",=SUM(U25+2)

See if this does what you want...

=IF(U25="","TBD",U25+2)

Thank you that worked perfectly.

I need to make one more modification to the formula in another cell.

If the value in column X is TBD it will place a TBD value in Column Y. Otherwise it will take the date in column X and add +1 to that value in column Y so it returns a date. I tried several variations of you formula but its not working.

Thank you

Tom

I need to make one more modification to the formula in another cell.

If the value in column X is TBD it will place a TBD value in Column Y. Otherwise it will take the date in column X and add +1 to that value in column Y so it returns a date. I tried several variations of you formula but its not working.

Based on your description, I think this should work for you...

=IF(X25="TBD","TBD",X25+1)

Thank you again. That worked.

Happy Holidays!!!

Replies
0
Views
103
Replies
15
Views
234
Replies
1
Views
150
Replies
6
Views
322
Replies
9
Views
241

1,203,082
Messages
6,053,420
Members
444,662
Latest member
AaronPMH

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back