Forum Discussion
Use IF statement in Excel with set of cells
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
14 Replies
- Perhaps, this is what you need:
=(MIN(C4:C$33)<C$40)*C4Thanks 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
- You need no MIN. Thus, what you need is:
=(C4<C$40)*C4
The above formula returns either C4 or 0.
