Forum Discussion
Solved
excel IF formula
Hello, I have a commercial dive school and am creating an excel spreadsheet to calculate dive minutes and allocate these minutes to specific columns which represent different dive depth. This is ...
I'd enter the thresholds 0, 33,49.5 etc. in a row above the cells where you want the results. In the screenshot below, they are in J6:N6. I also added a value larger than the deepest dive in O6.
The formula in J7 is
=($G7>=J$6)*($G7<K$6)*$G7This can be filled to the right to N7, then down.
I'd enter the thresholds 0, 33,49.5 etc. in a row above the cells where you want the results. In the screenshot below, they are in J6:N6. I also added a value larger than the deepest dive in O6.
The formula in J7 is
=($G7>=J$6)*($G7<K$6)*$G7This can be filled to the right to N7, then down.
Brilliant, it works perfect! thank you so much, Catherine