Actually, you probably want this formula;
=IF(B10,"Unassigned","")
Where the last 2 "" will keep cell the current cell blank. Or, if you want
a text condition in the current cell, just place that text condition between
the last 2 quotes, or remove the quotes and place in a numeric value.
--
"...I''m just a simple man, trying to make my way in the universe..."
"T.R. Young" wrote:
Place this in the cell that you want:
=IF(B10,"Unassigned")
Works if B1 is number or text.
--
"...I''m just a simple man, trying to make my way in the universe..."
"flyingby" wrote:
1-If any row in column A is empty enter "Unassigned" but only do so if
Column B in that same row is not empty
2-If any row has empty fields in both column A and B switch column c of
that same row to column D of the prior row.
I need to do this for 14k rows is there any formula or macro that might
be able to do this?
--
flyingby
------------------------------------------------------------------------
flyingby's Profile: http://www.excelforum.com/member.php...o&userid=27844
View this thread: http://www.excelforum.com/showthread...hreadid=473523