I have a comic book collection.
Column B is what i paid column C is what the true value of
the comic book.
When i purchase a book and enter in my price, i want it to
show the C column in a different cell. All of column C has
all the value of the comics. I use the IF statement:
=IF(B4=" "," ",C4)

the staement if fine, although i cannot get it to work for
entire column, only one cell at a time.

=IF(b4:b23=" "," ",C4:C23) this does not work.

When i type a price, i would like only the cells (in cell
B)that have a price to add column B to a different cell.

please help