hey guys so I have a formula here where it is supposed to only activate if a cell in the B column is blank and when a cell in the A column is not blank. When it does activate it takes the value in A and puts it in the blank B cell. here is the code:
=IF(AND(not(isblank(A)),isblank(B)), B, A)
the problem I'm seeing is that I want this formula to be put on certain blank cells in the B column. is there a way for me to select all of those blanks in the B column and then add the formula to all of them at once so it doesn't mess with the cells that already have values in the B column?
Aucun commentaire:
Enregistrer un commentaire