Returning select results using a conditional operator

[chkn89]

I have a small set of data that has 3 columns of numbers.
The first column is all positive values, the second column has either negative or blank values. In the third column, I want to return the positive values in the first column if they are greater than the value in the second column. I've attached a small series of numbers to better illustrate what I'm trying to convey.

I'm trying to apply this to a bigger spreadsheet and the formula I have for the attached spreadsheet wont work on the bigger set of data. (Note: The bigger spreadsheet has lengthy formulas).

Is there way to do something where if the second column is blank, it returns the value in the first column?
I tried doing this to no avail:

"IF(OR(A2>B2, B2="", A2, B2)"

[FlameRetired]

I am confused. It appears your formula does exactly what you describe in Post #1.

What am I missing? What should those figures in column C be then?

[Punnam]

Please Login or Register  to view this content.

is this what you are looking for