if function and or

Hi, I need help with a formula and keep getting Spill errors. What I am trying to do is say if the range A1:A100 = Anthony and E1:E100 = 1 (on another tab) then add H1:100 (on that other tab) that meet that criteria and divide by B15 on tab where formula is entered. Basically I need this...

Hi! If anyone could help with this, that would be very very helpful! I am trying to identify in Cell U2, people who either missed a class many times in once month, or consecutively missed classes in the following months. So I would like Cell U2 to say "TRUE" if either S1 or T1 say "TRUE". I...

Hi there, I am trying to create a new column in my dataset that will display a "yes" if ANY of the three criteria are met and a "no" if none of the criteria are met. For example if someone participated in year 1 and scored a 2 or above OR participated in year 2 and scored a 2.5 or above OR...

Hey Gang, I am attempting to create a dynamic chart where info hides or appears using a checkbox. I have been able to make it happen for EITHER the vertical OR the horizontal, but cannot figure out how to do both. In other words, I have multiple individuals on the vertical plane and multiple...

I'm trying to create a code that will make a selection of cells in a row automatically merge when a value in column A appears. If the value "Group 1" or "Group 2" appears in cell A2, the range A2:N2 should merge. I'd need to use this code in other rows of the spreadsheet too if possible, and...

I have a list of locations, with their coordinates, and I have a set of regions of which I have the coordinates of the border points. Now I would like excel to specify for me in what region every location is. I was thinking of using a nested IF function, but I have up to 20 regions so I am...

Hi, i have more than 10000 rows and contain similar data with date and sales. i would like ton consider sales example ( 02-01-2016 00:00:00 TO 02:01:2016 05:00:00) sales as 01-01-2016 ites mean bitween 00:00:00 TO 05:00:00 salesa will be as previous day sales. <tbody> <tbody> Date...

Good Afternoon! I'm stuck, please help. (FYI, this is my first time ever using a help thread, please let me know what I can do better in order to communicate my issue - Thank you!) Here is what I am trying to accomplish: If F2 = 5 then I need to multiple M2 * 1 If F2 = 10 then I need to...

The current formula: B2 is a given number. I enter C2 and the below formula calculates D2 based on the following: For every 2 units higher that C2 is than B2, D2 will go up 1. For every 3 units below that C2 is than B2, D2 will go down 1. Below is that formula that is entered into cell D2...

Hello all, I was on this forum a while ago and someone helped me create a spread sheet to track my golf league. It worked perfectly but now we have adjusted the "rules" of scoring and I need help. The current rule int he spreadsheet is each player has a given quota (B2). The points are...

Hi there, I have four 1 year long periods were a "special offer" was available and im trying to build an if function in B2 that identifies whether the offer was available on a random date (B1). <tbody> A B 1 Random date Dec 04 2 Offer available 3 4 nov 03 nov 04 5 apr 06 apr 07...