Populate cell based on contents of a different cell, from ANOTHER cell

[amythompson62]

Hi,

I am trying to figure out a way to do this it, 'seems' like it should be rather simple - I've been trying the IF function but I only seem to be able to populate with text rather than the actual contents of a cell.....

I have 1-2 tests conducted on a set of samples, with test 1 run as standard, and test 2 run based on the outcome of the first test:

If the first test (Cu1) has high values (greater than 10000) then >10000 is shown in column 1. If the value is less than 10000 then a numeric value is shown.
A second test (Cu2) is then conducted on all samples with Cu1 values greater than 10000 and the value for that indicated in column 2.

I want to populate a 3rd column based on whether there is a value (or not) for Cu2 in column 2.

ie:
If Column 2 (Cu2) has a value in it, then Column 3 (CuFINAL) should populate with that value . If it Cu2 doesn't have a value and is empty then whatever is shown in Colum 1 (Cu1) should populate into CuFINAL.

Cheers,
Amy

 

[radhak]

assuming your data (Cu1) starts on A1, Cu2 on B1, and the 3rd column is C : place your cursor in C1, and type =if(isblank(B1),A1,B1) then copy that cell all the way down that column

That formula states "if B1 is blank, put value from A1 here, else put value from B1"

(obviously your row/column references might be different)