I have 3 columns of numbers:A,B,C. I want to populate column C with the
number in column A only if there is no number in column B

example
A B C
1 blank 1
2 3 3

Hi

Try this in column C:
=IF(B2="",A2,"")
What do you want in C if B contains a number? If it is B, try this one:
=IF(B2="",A2,B2)

Hope this helps.
Andy.

"leo" wrote in message
...
I have 3 columns of numbers:A,B,C. I want to populate column C with the
number in column A only if there is no number in column B

example
A B C
1 blank 1
2 3 3

Sub Button1_Click()
10 For a = 1 To 1000
20 If Sheets("Sheet1").Range("A" & a) = "" Then r = a - 1: GoTo 40 Else
GoTo 30 ' Looks for end of list
30 Next a
40 For b = 1 To r
50 If Sheets("Sheet1").Range("B" & b) = "" Then
Sheets("Sheet1").Range("C" & b) = Sheets("Sheet1").Range("A" & b)
60 Next b
End Sub


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=508073