FORMULA HELP PLEASE!
 

I am working on a project for my job and need a page numbering formula that
says:

Cell x is 3
unless Cellxx contains data, then cell x should be 4
unless cell xxx contains data, then cell x should be 5
unless cell xxxx contains data, then cell x should be 6

Can anyone help me? This is for a workbook that contains linked pages on 5
separate tabs.

FORMULA HELP PLEASE!
 

Try this formula in cell x:

=IF(cellxxxx<"",6,IF(cellxxx<"",5,IF(cellxx<"", 4,3)))

Biff

"Solograndma" wrote in message
...
I am working on a project for my job and need a page numbering formula that
says:

Cell x is 3
unless Cellxx contains data, then cell x should be 4
unless cell xxx contains data, then cell x should be 5
unless cell xxxx contains data, then cell x should be 6

Can anyone help me? This is for a workbook that contains linked pages on 5
separate tabs.

FORMULA HELP PLEASE!
 

PERFECT!!! Thank you so much. Project complete!! Everyone will be happy
thanks to you.

"T. Valko" wrote:

Try this formula in cell x:

=IF(cellxxxx<"",6,IF(cellxxx<"",5,IF(cellxx<"", 4,3)))

Biff

"Solograndma" wrote in message
...
I am working on a project for my job and need a page numbering formula that
says:

Cell x is 3
unless Cellxx contains data, then cell x should be 4
unless cell xxx contains data, then cell x should be 5
unless cell xxxx contains data, then cell x should be 6

Can anyone help me? This is for a workbook that contains linked pages on 5
separate tabs.

FORMULA HELP PLEASE!
 

You're welcome. Thanks for the feedback!

Biff

"Solograndma" wrote in message
...
PERFECT!!! Thank you so much. Project complete!! Everyone will be happy
thanks to you.

"T. Valko" wrote:

Try this formula in cell x:

=IF(cellxxxx<"",6,IF(cellxxx<"",5,IF(cellxx<"", 4,3)))

Biff

"Solograndma" wrote in message
...
I am working on a project for my job and need a page numbering formula
that
says:

Cell x is 3
unless Cellxx contains data, then cell x should be 4
unless cell xxx contains data, then cell x should be 5
unless cell xxxx contains data, then cell x should be 6

Can anyone help me? This is for a workbook that contains linked pages
on 5
separate tabs.