Choose the cells where there is a value

  • Thread starter Thread starter firroo
  • Start date Start date
F

firroo

Hi all,

I have two columns where there is a value in one of them ( column for
negative & the other one is positive ) I want to have a third column shows
the values of the 2 columns before, as I have 500 rows to look at. Can any
one help on this.

Thanks in advanced.

Regards
 
Say data is in columns A & B. In C1 enter:

=IF(A1="",B1,A1) and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Having Blank Cells, etc. ? 1
Chart in Excel 2007- Positive & negative value columns 10
How to determine the value within specific cell position? 5
Filtering with SUMIFS 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
retrieving values from a certain column 2
counting blank cells within two columns 2

Back
Top