A
anthony
I have a comic book collection.
Column B is what i paid and 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 value 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
Column B is what i paid and 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 value 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