Forum Discussion
Beth Rodriguez
Aug 03, 2017Copper Contributor
Excel conditional if statement
I am trying to create an if statement to calculate accrued hours every 125 hours. THe statement that I have now is =IF(C2>$C$1,1,0) where $C$1 = 125 but I need this every 125 hours and only 1 every ...
Detlef_Lewin
Aug 03, 2017Silver Contributor
Beth,
are you looking for this:
=COUNTIF(C$2:C2,">"&$C$1)=1