FORMULA HELP PLEASE!

S

Solograndma

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.
 
T

T. Valko

Try this formula in cell x:

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

Biff
 
S

Solograndma

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