Get instant live Excel expert help with IF Functions

In Excel, if you click on the right corner of a cell and drag it down a couple of rows, what will happen?

I would like to know if I can change the default sort in Excel 2016. I have many sheets to sort and each time I need to go to Data>Sort then change Sort by from the current default Formula no to Product name. Then change Sort on from Values to Font color & then change order to Red color & then change to On Bottom. Is there any way to set the default sort with these parameters so I dont need to do this every time?

I am trying to create a formula where Excel will tell me the number of days that have passed in the month based on the date that I entered. For example, if I enter 4/23, I want Excel to spit back 23. Or if I have two dates, can Excel read those dates and tell me how many days were in April within that time frame? For example, 2/23 - 6/30, I want Excel to tell me 30. Thank you.

I want the first 4 digits of column AC, AD and M to match. if not highlight all three cells in red if not matching. (note: first 4 digits only)

need to create if formula for values in column A to multiply column h and produce result in column I example if ($A$2:$A$244=5, $H2:$H$244*65)

I'm trying to make cell F2 equal E2 if F2 is less than E2 and stay the same if it's equal to or more than. This is my current formula which gives me a #REF! error. =B2-(C2*D2) =IF(F2<E2,F2=E2,F2)

yesterday i was told to use a formula =2&right(a1,6) to create number sequence from 1.12.13 to 2.13.14 basically creating same list from left to the next column on the right . i was wondering if you could explain how the sequence of numbers is created using all 2's .

Hi! We are working with a school project, and are writing about housing prices. We have different variables that can explain the development in housing prices. We want to compare four cities, and find out if there are differences in the coefficients. The problem is that we dont now how to do this in excel..we have heard about the F-test, but we can't seem to figure this out.

I am trying to set up a formula which calculates a discount regime - 10% if the price is over £2,000, 5% if it is between £1,000 and £2,000, zero if under £1,000. I can do the first two bits but not the free bit. It just keeps saying "FALSE" instead of zero.

I am looking to show the value from a different cell if Yes is shown in a different cell in a different column. If "Column H" of "Tab A" is shown as "Yes", then I want to add the value of "Column B" of "Tab A" into "Column A" of "Tab B". I am then looking to do a further action relating to this. If "Column A" of "Tab B" is populated by the above, I then want to show the values from "Column E" and "Column F" from "Tab A" in "Column B" and "Column C" of "Tab B". Can you help me please?