Forum Discussion
Multiple IF'S
Hi, I've been trying to do this for ages! I've got three cells on worksheet 1 and if any of them drop below 60, I want another single cell on worksheet 3 to increase by 1. I've been trying t...
If the cells from which you want to evaluate whether any of them is below 60 are in Sheet1!D2:D4 and the cell you want to increase by 1 is in Sheet3!A2, the formula in Sheet3!B2 is:
=(COUNTIF(Sheet1!$D$2:$D$4,"<"&60)>0)+A2
Instead of hard-coding 60 in the foregoing formula, I suggest you store in a cell, such as Sheet3!B1, so that you can modify its value without modifying this formula:
=(COUNTIF(Sheet1!$D$2:$D$4,"<"&B1)>0)+A2
Note that the foregoing formula returns the value in Sheet3!A2 increased by 1, if any of the cells in Sheet1!$D$2:$D$4 is below 60; otherwise, it returns the value in Sheet3!A2 as is.
=(COUNTIF(Sheet1!$D$2:$D$4,"<"&60)>0)+A2
Instead of hard-coding 60 in the foregoing formula, I suggest you store in a cell, such as Sheet3!B1, so that you can modify its value without modifying this formula:
=(COUNTIF(Sheet1!$D$2:$D$4,"<"&B1)>0)+A2
Note that the foregoing formula returns the value in Sheet3!A2 increased by 1, if any of the cells in Sheet1!$D$2:$D$4 is below 60; otherwise, it returns the value in Sheet3!A2 as is.
