How do i create if/then using multiple cells?
For example, I have data that i want to compare from D50 to D55 and i want to create and if and then statement saying that if all the values from D50 to 55 are greater than a number, then it passes. I wanted to do this for multiple groups of cells.
Any suggestions? Is there a way rather than individually listing out each cell with a if/then statement.
i hope im making sense...
thanks!
For example, I have data that i want to compare from D50 to D55 and i want to create and if and then statement saying that if all the values from D50 to 55 are greater than a number, then it passes. I wanted to do this for multiple groups of cells.
Any suggestions? Is there a way rather than individually listing out each cell with a if/then statement.
i hope im making sense...
thanks!
