ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Column of Data - Set Next Column Value Conditionally (https://www.excelbanter.com/excel-worksheet-functions/89133-re-column-data-set-next-column-value-conditionally.html)

Gary

Column of Data - Set Next Column Value Conditionally
 
Enter this in B1 and drag it down.

=If(A1="DDD","mule","donkey")




All times are GMT +1. The time now is 10:20 AM.

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