Excel Formula

J - Jan 27, 2009 at 11:05 AM
 J - Jan 27, 2009 at 11:29 AM

Is there an Excel Formula that can be used for the following:

If Column F = Name and Column G and/or Column H Does NOT = Name or is NOT Blank, then Replace Column F with Column G OR Column H

1 reply

well j
your question is not quit clear can u please make it more clear
I am working on an Excel Spreadsheet and within Columns F, G, H, & I.
Everytime Column F is SC and Columns G, H, or I have anything but MB then I need to put one of from the 3 columns into Column F to replace SC.
This is my email.