In the data sheet I'm working on, I want to calculate the Min, Max, and Average for each row and have the formula recognize the cells that have BDL as being = 1.35 without changing the value of the cell to 1.35. Is there a way to do such a thing? I'm pretty sure I've seen it done in the past. I believe I've seen a constant value added on to the end of functions.
