ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with a formula!!! (https://www.excelbanter.com/excel-worksheet-functions/15998-help-formula.html)

mel

Help with a formula!!!
 
Trying to create a formula to check to see if cells in a column are blank, if
blank copy text from another cell in another column. Want this formula for
several cells in a column.

Mel

Thank You!!!

"Debra Dalgleish" wrote:

You can use an IF formula. For example:

=IF(D2="",H2,D2)

If you need specific help, you could give details on the layout of your
worksheet, and what cells you want to check.

mel wrote:
Trying to create a formula to check to see if cells in a column are blank, if
blank copy text from another cell in another column. Want this formula for
several cells in a column.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com