“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have the following formula in cell BT27:
=VLOOKUP(BV27,'Rates NEW'!F:H,3,FALSE)+VLOOKUP(BO27,'[Timesheet Input DO NOT MOVE OR RENAME WORKING TEST.xlsm]Pay Elements'!$B:$H,7,FALSE)
The result in this example in cell CR4 is 35 But I want it to also look at cell BD4 and if cell BD4 contains “CS” I want the maximum value in cell CR4 to be 30.
How do I do this please?

Solved by X. U. in 21 mins

There are 50 part numbers that we are tracking usage for. For the past 60days, we have recorded the number of times each part has been used. We now want to determine how much inventory we should hold of each part to ensure availability. To make this determination, we need to know the number of times a particular part may be used in the time it takes to order and replenish (Lead Time).
For the 50 Part Numbers listed in the attached file, find the Maximum Consumption over the course of the specified part lead time for a 60day period.

Solved by G. Q. in 20 mins

how to find the max of a function? I need a formula that will have a maximum limit of 8 in the first column and carry any excess to the second column.

Solved by M. E. in 21 mins

Hello,
I have an employee attendance tracker sheet which is protected by maximum nos 10, I want to be add more employees on it, like 100 or more, is there any way? it is VBA protected. I cannot upload this file because it macro enabled.

Solved by G. U. in 25 mins

Hi I need to create a tool that will allow me to look at price per serving numbers (maximum, average, minimum) based on cuisine type and dish category. For instance, I need to select a cuisine type (e.g. Mexican) and a dish category (e.g. Entree) and get the maximum price per serving, average price per serving and minimum price per serving for the data set provided. Is there anyway someone can help me do this?

Solved by A. F. in 19 mins

What is the maximum number of trips completed in a 6-hour period throughout the 2 weeks?

Solved by C. L. in 12 mins

I need to make a chart to identify key products that drive maximum revenue

Solved by X. J. in 21 mins

I am currently handling a large scale data (ranging in some thousands in rows and as many in columns) I am trying to find a steepest point two ends of the steepest slope of the CURVE the two variables say column1 and column2 variables can have.
I am not looking for local maximum. I am looking for a global maximum.
Please help?

Solved by A. B. in 29 mins

I'm trying to solve various outcomes for a football match to show the optimum amount that could be wagered across 16 different outcomes, to maximise return (as a percentage of the total wagered amount). The attachment shows the simple formula I've been using but at the moment I have to manually change the amounts in Column D. Is there a way Excel can simultaneously change the values in Column D to reach either the maximum percentage return shown in Column G or to hit a target return rate?

Solved by X. J. in 17 mins

Can you create an if statement to return a number with a maximum value. Even if the percentage is over 100%

Solved by E. W. in 25 mins