Combine formulas into 1 formula

[pwill]

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

 

[jmacleary]

Hi there. Try: =ROUNDDOWN(COUNTIF('Sheet2'!A:A,0)/14,0)*14+2 (not tested)

John

 

[pwill]

Thanks jmacleary,

I will give it a try and let u know how I get on

much appreciated

pwill

 

[pwill]

Hi there. Try: =ROUNDDOWN(COUNTIF('Sheet2'!A:A,0)/14,0)*14+2 (not tested)

John

Hi jmacleary, just what I needed, works perfect

Thank you

pwill

 

[Kamolga]

Hi there. Try: =ROUNDDOWN(COUNTIF('Sheet2'!A:A,0)/14,0)*14+2 (not tested)

John

It does work, as expected.