## Possible IF Function help

I would like to build a spreadsheet that simulates a Keno Ticket. 10 columns of 8 rows for a total of 80 cells. Each cell in each row individually numbered …

## FORMULA HELP COMPARING TWO COLUMNS OF DATA THAT ARE NOT AN EXACT MATCH

Hello, If anyone could help me with this, I would greatly appreciate it. I am looking for a formula that will help me with the following situation.  I …

## Conditional Formatting

Hi there,   I have a roster where i want to implement conditional formatting.   If you see my roster below, you will see the green and red …

## Cross department check

I have a list of users and their shared mail boxes they use within their departments.   There are some mailboxes shared within one or more department …

## Vlookup with Today() formula

The first table is the input table.  The second table is the for the results. The result should display as follow:  – If the end date of the …

## IF Function

Hi, I am just wondering why my IF function is not working correctly. Any help is appreciated.   By:

## Excel If and AND Functions

Hello,   Please could you help. i need a formula for IF Column B had data in and Column J is Empty then do this …

## Updating Pricing Question

Hi, I am tryign to combine a VLOOKUP function and an IF statement. Basically I want to quality check pricing for a product using an ID number, so do a …

## EXCEL IF function using date

Hi, I’m trying to run an if function in excel which will add up the numbers in one column depending on the values in 2 other columns.    The 3 …

## Excel Formula

Hello Everyone I want to ask a question relating excel 2013. I have 2 columns A and B respectively.Now my question is that suppose there are 2 vaues. In column …

## IF, OR Formula Help!

Hi I need to create the following formula in Excel – please can you help! If A2 is less than 5 OR A3 is equal to or greater than 3, then A4 should read …

## IF Function

I have column a which has dollar figures in it. I have column b which I want to have a formula to fill in.  That would be If amount in column a is less than …

## Nested IF Statements Matching Age to School Year.

I am trying to create a spreadsheet which matches a Child’s date of birth to their school year. For example: Date of birth Year group 1 September 2008 to …

## Find Matching Words in Text String with Excel Formula

Having a bit of difficulty determining where I’m going wrong but here is what I’m trying to do: I have a column labeled “Category” and …

## Averaging Marks Depending on their Value

Help Please! I have the following information   CAT 1 CAT 2 SUP 1 SUP 2 AVERAGE MARK 48 55 67     50 50       30 61 87       I need to …

## Using the IF AND Function in Excel

I have 2 criteria. If sales in a cell A1 are between 2500 and 4999.99, then in Cell B1 show 500, but if sales are greater than 4999.99 then show 1000   …

## IF/Lookup query

I have a spreadsheet which requires some additional formula inserted.   I need the formula to read cell a and if it meets a particular requirement to then …

## 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 …

## Applying a different sum depending on the value of a certain cell

Hi Hopefully you can help me please. I need to add either 90 days or 180 days to a date (for this example say this date is in cell A2).  Whether I add 90 …

## saving a if statement, once satisfied, automatically

Hi I was wondering is the following is possible to perform   So i have an if statement and was wondering when the if statement is satisified and therefore …

## Nested IF Statement to Calculate Income & Expenses

What have I done wrong here? =(IF( E16,(G15+E16))(F16,(G15-F16))) to add or deduct from a balance.

## Help with Nested IF Formula

I need a formula that will do the following: If the current target is within 33% of the proposed target, increase/decrease to the proposed target, if the …

## If Function – If False Do Nothing

The IF function has the following syntax: IF(logical_test,value_if_true,value_if_false) My questions is,If I don’t want the function to take any action …

## If Functions

I have 53 week numbers along columns AE to CE In column I is the total Quantity. In column Y is the start week number – 7 in this case. In column Z is …

## Nested IF Function in Excel

Hopefully you have come to this post after reading my previous article about using IF functions in Excel.  This is a next step to using IF in Excel.  …

## Writing IF Statements in Excel

The IF Statement in Excel is a good tool, but is quite often little understood by Excel users.  The IF statement tests a value and then says whether it is …