# maximum if statements

1. ### Cumulative max with IF AND statements

I need help with creating the correct formula for the Employer Matching column (Column G). The employer matching formula is the lesser of 50% up to 6% of Gross Wages OR a maximum of \$8,400 (which is 3% of \$280,000). Once Gross Wages reach \$280,000, the employer match will no longer accrue. Also...
2. ### Array Function to Return Name of Largest Value in a Range

I'm working on an array formula to return the name of the value with the largest value in a range. In column A, I have the cities names and in column B I have the pouplations that correspond to the city name. I can do an if formula such as =IF(B3=MAX(\$B\$2:\$B\$44),A3,"") and that will provide...
3. ### excel error

I am using a max function to find the max of an array found by multiplying two conditions to arrive at a single array: =MAX((Data!\$B\$3:\$B\$202=Analysis!\$B4)*(Data!F\$3:F\$202)) where the first condition is used as a true false (1 or 0) to only count the following condition when it is met. It...
4. ### MaxIf Function

I would like to write a formula that looks at the last month with a percent value greater than zero, then return the percent value in a specific cell. In the example below I want to display 85.0% in the cell. It should update each time data is entered for the following month. Here is the...
5. ### IF Statements How can I shorten this formula

I have been trying to create a spreadsheet that will look up references in in multiple tables in the worrkbook. I have come to a problem with IF statements. I have reached the maximum IF's I can use, however I need to reference three more tables, as well as it needs to differentiate between...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...