Hello, I have a spreadsheet that contains 5 sheets. I
would like to add a function that calculates the number of
pages only if a value exists in a field on a page. I
can't seem to use the IF statement because I actually need
an IF/ELSE statement. How can I do this.

My example is as follows:

On page 1: =IF('PAGE2'!R20<0,"2","1") but if there is a
page 3 or 4 or 5, etc. that contains values, then how do I
use this IF statement?

Please let me know if you do not understand what I am
trying to ask.

Thank you very much,
Grace