us IF statements

[Anthony]

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

 

[Tom Ogilvy]

That is true, but if you put

=IF(B4=""," ",C4)
you can then select that cell and copy it,
row 5 down to row whatever and do edit=>Paste

Excel will automatically adjust each formula so it refers to that row.

So you don't have to enter the formula by hand in each cell - it sounds to
me that is what you want to avoid.