Get instant live Excel expert help with IF Functions

I have a directory in excel with AD column for university. I want show the location of the university in column AE . I have a separate Tab with a list of universities (column A) and locations (column B). What is the correct formula? I think it is an If function.

I am trying to make a formula that will give me future dates (assessment) regarding risk falls. Example if the score is equal to 10 and above assessment should be assessed every 4 months but if it is 9 below it should be 6 months from the date last assessment was made.

Im trying to write in vba ( And failing badly) code that searches (row by row) in column F, for 10 specific phrases ( not all of them will be present) and then return a true or false, If True is found it then needs to go the correct row on a different sheet, and the in a set column colour the corresponding cell.

What formula should I use to show the difference between two percentages? For example, if A1 is 75% and B1 is 25%, I want C1 to show -50% (the change between A1 and B1)

I need help with formula in column L please. My intent is that if cell H is blank, then return the value in cell G, if false return nothing.

If something is going to happen tomorrow, highlight the row/cell yellow. If something is going to happen within three days, highlight the cell green. How do I sum the total payments for a given day? How do I create a macro to re-configure the list to start at today's date How do I create a formula that results in a 0 instead of #N/A?

I'd like to create a formula that says something like sum(d1*1 if D2=5 or 2 if d2=10)

I need the inventory qty's to "trickle down" when I change the Target MOS (Months of Stock) for SK which is our priority. Basically, if we give SK X MOS, how many MOS does that leave AMZ and Wholesale? Also noting that each location has a different 1 Month Average, thus the Months of Stock (MOS) are different for each location.

I have list of tickets data and need to apply Vlookup and IF Statement to it

I am creating a spread sheet that will have a column that will have the drop down of yes and no in the next column to the right of this option I want it to auto add. example would be if yes answer is chosen I would want to have 165.00 put in the cell to the right of the answer if no is chosen then it would be a zero. how can I accomplish this?