# Archive by month October

## Excel Line Graph (Multiple Data Sets)

I want to create a line graph (of tidal data).   1 data set has a row for every 1 second of data, and the other has a row for every 15 minutes of data. …

## Student

I’m trying to figure out how to produce an error message if the person doesn’t enter an actual string when prompted to enter a product code. If …

## Excel Formula for Multiple IF Function

Hi, I hope i explain this properly, i am going to give you an example below. If D3 = 1 to 50, D4 needs to = 1 If D3 =51 to 100, D4 needs to = 2 this continues …

## IF Function Including Count Colour

I was able to count cells by their background color by the following: Function CountColour(rng As Range, clr As Range)Dim c As RangeFor Each c In …

## IF-AND Compare Month and Year

I’m working on a sheet that has a calculated date (i.e., condition met,  date +/- days = result). I don’t need the day field, but do need to …

## Using IF and MAX Function Together

Hi, I am look to make my data entry spreadhseet a little neater. I have two columns of data with a column to the right to list the maximum value between them. …

## Calculate Difference Between Dates if Condition Met Excel Formula

Hi – hope you can help. I have a spreadsheet with the following columns a) Qualified b) Finished c) Length of Partnership (there are other columns but …

## Vat for Excel

hello. I have an excel assignment and one of the questions is asking me to calculate the new price of a good(vat inclusive) being given the Net price and the …