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...
Perhaps, this is what you need:
=(MIN(C4:C$33)<C$40)*C4
=(MIN(C4:C$33)<C$40)*C4