Software

Ask something
Question Locked

Microsoft Excel 2003

0 helpful
2 replies

by dandgfrazier

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to be able to automatically move a cell value if a specific value is listed. For example there was a zero in line 9 column H I would like to move the value in cell address line 9 column G to line 9 column J. Does anyone know how to do this? Thank you in advance for any information you could give.

2 replies

by locolobo

would it be acceptable to put the value in cell column J? If you want to do the first you will probalby have to write a macro. To do the latter simply requires an IF statement:

=IF(H9=0,G9,"")

would go in cell J9.

This discussion is closed to new replies.