“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

SPREADSHEET SOFTWARE USED:
Microsoft Excel 97-2004 (.xls)
MY QUESTION IS ABOUT:
IF STATEMENT
DESCRIPTION:
I have a data with 4 columns I want to put two conditions on two different columns( Column1 and column2) and if this both conditions met then need their corresponding columns(column 3& column 4) values. using excel functions only (not using sort&filter tab) is there any way to do? enter image description here IF in column1( BAC US ) and in column2(B) it should give 444 in c3 and 9.825 in c4 same for 4th row

Solved by V. S. in 21 mins

Trying to open an excel document I didn't know had issues as it has saved fine before. However now I get this error message appearing and the one tab that had the most work done on it is empty: "Replaced Part: /xl/worksheets/sheet7.xml part with XML error. Illegal qualified name character. Line 2, column 341633.
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)"

Solved by I. J. in 29 mins

I am trying to figure out the formula to use that would take the net price (column B) multiply it by 1.285 and then replace the final two digits with ".95". I want every list price to end in .95, but

Solved by B. Q. in 29 mins

Help! I can't figure out what I'm doing wrong! I need to check a column from worksheet 1 for specific text. If it is true, I need to copy the line of cells to worksheet 2

Solved by E. D. in 23 mins

Making a table for inventory: and its auto filling the whole column instead of just the cell

Solved by Z. B. in 20 mins

I have a 2 worksheet workbook. Sheet1 is the start. i want the data in columns "A" and "B" to copy and paste into columns "B" and "C" in the first available row on Sheet2 if "Yes" is entered into Column "F" in Sheet1. The macro should search all of Sheet1 and repeat the process until all occurrences of "Yes" are moved to Sheet2. The macro should also delete the entire row on Sheet1 is "No" is entered into column "F". Lastly, once the "Yes" data is copied to Sheet2 the row on Sheet1 should be deleted.

Solved by I. H. in 15 mins

I am trying to get a column of percentage (GRADES) using the COUNTIF function to excel count cells with value or text, then SUM only those cells. Here's the formula I have so far, but it is not working; =COUNTIFS(C8:C41,"<>"&"",F8:F41,"AVERAGE")

Solved by M. E. in 30 mins

I need a formula that will search column B for a given ID number and then find the most common text associated with that ID number that occurs in column E

Solved by K. D. in 28 mins

I'm making a spreadsheet for some pricing things for work. I wanted one column to be the price, the next column to be the quantity, and the third column to be the total price. Is there an easy way to accomplish this?

Solved by V. S. in 24 mins

In column S if there's data that is bring back the value of 0 (as opposed to it just being blank) would like to bring back a value such as "0 - revised qty". several cells are looked at to obtain that qty

Solved by D. W. in 28 mins