Hi can anyone help?
I have 2 formulas, one that counts and the other rounds down.
sheet1 "P2" has
=COUNTIF('Sheet2'!A:A,0)
Sheet1 "U3" has =
=ROUNDDOWN(P2/14,0)*14+2
I am trying to combine =COUNTIF('Sheet2'!A:A,0) and =ROUNDDOWN(P2/14,0)*14+2 into one formula using cell "P2" to get the same result as in "U3"
Any help would be appreciated
Regards
pwill
I have 2 formulas, one that counts and the other rounds down.
sheet1 "P2" has
=COUNTIF('Sheet2'!A:A,0)
Sheet1 "U3" has =
=ROUNDDOWN(P2/14,0)*14+2
I am trying to combine =COUNTIF('Sheet2'!A:A,0) and =ROUNDDOWN(P2/14,0)*14+2 into one formula using cell "P2" to get the same result as in "U3"
Any help would be appreciated
Regards
pwill