May 21 2019 09:39 PM
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 this formula:-
=IF(Sheet1!D2<60,1,0)&IF(Sheet1!D3<60,1,0)
but instead of changing to 2 if 2 cells drop below 60, it displays 11.
Any tips where I'm going wrong?
Thanks in advance of any suggestions!
May 21 2019 09:51 PM
May 21 2019 10:59 PM
May 22 2019 10:58 AM
May 22 2019 10:59 AM
May 22 2019 11:09 AM