Apr 26 2019 10:27 AM
Hi,
I need to use the if statement with set of cells, say C4:C33, and the return for TRUE condition is the same as cell value, while for false condition the return value is zero. The following is an explanation:
=MIN(IF(C4:C33<C40,C4:C33,0))
However, this form is giving invalid value because I am using the same set as a True result.
Anyone can give an idea how to do this please?
Thanks
Apr 26 2019 10:49 AM
Apr 26 2019 11:16 AM
Apr 26 2019 11:22 AM
Thanks for your reply, What I exactly want, is that, if the value of specifc cell in column C is lower than the fixed value (placed in cell C40) the the output from If-statement is the same value of specific C-cell, else, the output value is zero. C40 is only used for condition/comparesion and not used as an output neither in True nor in false conditions.
Thanks
Apr 26 2019 11:29 AM
Apr 26 2019 11:36 AM - edited Apr 26 2019 11:38 AM
Apr 26 2019 11:44 AM
Apr 26 2019 11:55 AM
Ok,
Lets us assume we have the following students scores:
Student No. Score
------------- ----------
1 41
2 20
3 23
4 27
5 30
6 10
7 49
the test maximum possible score is 50. That is the minimum success degree that student need to take for passing the exam is 25.
I need to find thclosest student score to 25 for failed students (below 25).
In this above example, the required score will be 23 for student no. 3...
What I am doing is that storing the 23 in a specific cell, say cell C40. and the students score are along column C.
then, follow anyone of the following algorithms:
1) find the minimum difference between C40-value and the student score which is bellow C40
2) find the maximum value of student score which is still bellow C40.
Thanks a lot for your help
Apr 26 2019 12:07 PM
Apr 26 2019 12:15 PM
Hi Twifoo: There is no column D, the following is what exactly happen:
Student No. Score
------------- ----------
C1 = 41
C2 = 20
C3 = 23
C4 = 27
C5 = 30
C6 = 10
C7 = 49
.
.
.
C40 = 25
C41 = closest score to C40 value and lower than C40 value.
This means, C41 cell have the formula I want to use to fulfill the required task.
In summary, there is a set of scores and I want to find the closest score to C40 value and lower than C40 value using one formula and store this value is cell C41.
Thanks
Apr 26 2019 12:21 PM
Apr 26 2019 12:25 PM
Apr 26 2019 12:28 PM
Apr 26 2019 12:35 PM
Apr 26 2019 12:44 PM