Search : in
By :

Excel Formula

Last answer on Jan 27, 2009 4:29:34 pm GMT J, on Jan 27, 2009 4:05:32 pm GMT 
 Report this message to moderators

Hello,

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

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Excel Formula » in :
Excel – Formula for cell calculation Show Excel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Excel formula to get the cell with the text Show
Excel Formula Display in Cell (Solved) Show
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Special characters ShowSpecial character codings HTML standards require all code to be written in 7-bit ASCII, which means that accented characters are not allowed. Despite this, current browsers recognise accented characters; you can enter accented characters directly...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

sandy2216, on Jan 27, 2009 4:24:47 pm GMT

Well j
your question is not quit clear can u please make it more clear

   
Reply to sandy2216

2

J, on Jan 27, 2009 4:29:06 pm GMT

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.

   
Reply to J

3

 J, on Jan 27, 2009 4:29:34 pm GMT

This is my email.

   
Reply to J
Ask your question Reply
They need your help