FORMULA HELP - IF Statement

[milwphil]

Good afternoon!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I need help with an ‘if’ formula:<o></o>
<o> </o>
What I’m trying to do is write it so that if there is data in cell F6 to bring in the F6 data;however, if no data exists to bring in a named cell “CODE”. If both are blank cells to have the cell blank.<o></o>
<o> </o>
This is what I have so far:<o></o>
<o> </o>
=IF(F6>=0,F6,IF(F6=0,CODE,""))

In the test data I have 6000 in the CODE named cell and blanks in F6...but the above formula is producing zeros.
<o> </o>
Any help you can provide will be greatly appreciated.<o></o>
<o> </o>
Thanks,<o></o>
Phil<o></o>

 

[kidwispa]

Try

IF(F6="",CODE,F6)

 

[milwphil]

Wow! Thanks for the quick response.

It worked perfectly....

I hate to be greedy, but would you mind if I take the question a step further:

I'm adding that formula to several consecutive rows in a column. The problem I'm having now is that the formula is doing what I told it to, but when the entire row is empty is filling the rows with "6000" per my test data.

I have that formula at the end of the row for about 200 rows....for rows that are completely blank(or incomplete), I'd like the formula to produce a blank cell rather than "6000."

If I have another dependent reference cell, how could I add a condition to only return 'CODE' if D6 has data in it. If no, data the cell is blank.

THANK YOU AGAIN!!

Phil