min value

Hello Everyone, You guys always blow me away with your solutions when I've needed them. Thank you! I have a formula, =Round((AW2*.85)+IF(V2="yes",-700),-2) and it works perfectly but I would like to add a min value of 4000. I have tried =MIN(4000,.....my formula, but not been able to get...

I have data of few months. <colgroup><col><col span="2"></colgroup><tbody> Date Name Value 01-04-2018 a 2 03-04-2018 b 2 05-04-2018 c 8 07-04-2018 d 3 09-04-2018 e 1 11-04-2018 f 3 13-04-2018 g 10 15-04-2018 h 9 17-04-2018 i 5 19-04-2018 j 7 21-04-2018 k 4 23-04-2018 l 5...

Hello everyone, I tried searching for a solution to this, but couldn't find exactly what I was looking for, so here I am. I have a list of thousands of items (with many duplicates) from different vendors and I need to be able to quickly pull the lowest cost of each item with the associated...

BLUF: Are the logarithmic basis (not the base) and the min value independent variables when graphing logarithmically in Excel? Details: I would like to graph vibration amplitudes, which are displayed logarithmically on both the x and y axes. I know how to change the axes to display...

Hi I am trying to create a program in VBA where I have an Array A and I am trying to Iteratevely find the minimum value in the array, get its position in the array and next update its value to an arbitrary large number (say 9999). The code I have come up with so far is something like this For...

Value Range Requirement 25.000 1750.000 17.000 17.000 1750.000 17.000 33.000 1750.000 17.000 18.000 1750.000 17.000 33.000 1750.000 17.000 47.000 1750.000 17.000 66.000 1750.000 17.000 21.000 1750.000 17.000 41.000 1750.000...