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

I need the value displayed to be no less than 0; if between 0 and 3 then display 0; if 6 or more then just display 6. So far I have come up with =(MAX(0;(MIN(6;($D27-2)+1)))) but this is still displaying values of 1 and 2

Solved by X. F. in 20 mins

I know I am doing something wrong but I need help fixing it, I need to get the min and the max from a pivot table and get the difference and find the maximum rate of change calculator

Solved by F. F. in 16 mins

Hi I have a column which gives me daily temperatures since 1975 till 2017. I am trying to calculate the cumulative deviation of temperature and trigger a payout if the cumulative is greater than 150 degrees celcius or 250 degrees. The deviation is based on 'triggers' so if the daily max temp is 30 and the trigger is 31 then the cumulative deviation is -1 and so on. I have a set of 6 triggers - 31, 33 35.5 38 39.5 and 39. How can I calculate this on excel?

Solved by O. C. in 13 mins

How to a calculate the following with a formula in a simulation:
I have to randomly select 18% of 100 customers that use a 7% coupons with a "Yes" or "No" as the result.
Information: I have 100 customers who purchase grocery from min $5 to max $250.

Solved by V. L. in 12 mins

I need a formula that returns values from min to max, from an array of 3 values. If there are repeats with those 3 values, it must return zero.
i.e. column 1 is always the minimum
column 2 is greater than column 1 or zero
Column 3 is greatest value or zero
there are not always 3 values in the array, in some cases value appear more than once in the array.

Solved by A. Y. in 23 mins

Hi i have 2 sheets that both have an "id" column and next to one of them is a column that says the manager for the id i want to like if they max it moves over the current manager to the right id on the first sheet its like 1617 id and names and i want to sort them with their right manager.

Solved by M. Q. in 13 mins

Hello, how to find max and min of a function? Also, I need help with problem in max indirect

Solved by V. F. in 21 mins

I have a formula that basically measures efficiency of an experiment ( so we get a value that should range anywhere from 50-100, however the procedure isn't quite accurate yet so we have values that are greater than 100) In order to use these values in our data calculations still we need to make everything that is over 100 just equal 100, instead of going through and hand changing everyone of them, is there a function in excel that I could use instead like maybe a max value or something?

Solved by I. D. in 13 mins

Data in column A =
AE0001
AE0002
AE0003
AE0004
AE1001
AE1002
AE1003
AE2001
AE2002
AE2003
AE3001
AE3002
AE3003
AE4001
AE4002
i want to type a formula that can return automatically look for data that starts with
AE0 and return me the max value i.e. AE0004 and look for
AE1 and return me tha max value i.e. AE1003 and look for
AE2 and return me tha max value i.e. AE2003 and look for
AE3 and return me tha max value i.e. AE3003 and look for
AE4 and return me tha max value i.e. AE4002.

Solved by C. C. in 26 mins

Need help tweaking a COUNTIF formula.. Max number of arguements

Solved by S. C. in 12 mins