## IF function multiple text columns

Hi, I am trying to display the final risk classification based on two text columns. In column A i have one of five predefined values (rare, unlikely, etc.) and …

Hi, I am trying to display the final risk classification based on two text columns. In column A i have one of five predefined values (rare, unlikely, etc.) and …

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 …

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 …

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 …

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 …

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 …

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

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

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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

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 …

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 …

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 …

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

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 …

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 …

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 …

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

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 …