Get instant live Excel expert help with IF Functions

How to round up in excel, my total needs to round up to the nearest .25, needs to look at another cell and if there is an entry split the total.

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

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.

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

If a cell value equals x I want that cell to display a string. For example. If a cell equals 1 I want that cell to display "DH1". If a cell equals 2 I want that cell to display "DH2" and if a cell equals 28 I want that cell to display "NH1"

Hello, I have a list of value from highest to lowest with different names next to the values. When i do a vlookup of duplicate values i get the same name. Is it possible to lookup duplicate values and if a name already exists in the worksheet it goes to the next name in the report?

Hi! So I am working in Excel and need to come up with a formula that says "in how many events did the US win a medal?" On a separate sheet, it shows the event name and which countries won bronze, silver, and gold. However, I only care about counting the event if US just won a medal, rather than double counting the US if they won two medals. Thanks!

I need help inexcel conditional formatting based on another cell color. In the file, the cell will not show based on there not being text in the 'Student Column", but the cell color coded with a uniform color if no data appears.

I need to know how to format a formula to make all cells with no 'Text' in another column not appear. Here's the formula as it currently is: =IF(AP8<0,"Worse",IF(AP8>0,"Better",IF(AP8=0,"None")))

I would like to autofill filtered columns with a series list of numbers and then unselect the filter and have the series list of numbers not change. For example if I associate a 1 with that row it remains 1 no matter the order of filtered rows. I am not sure if this is possible without an add-in or vba.