FORMULA HELP PLEASE!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this formula in cell x:

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

Biff
 
PERFECT!!! Thank you so much. Project complete!! Everyone will be happy
thanks to you.
 
You're welcome. Thanks for the feedback!

Biff

Solograndma said:
PERFECT!!! Thank you so much. Project complete!! Everyone will be happy
thanks to you.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

blank cell instead of x 2
Is this formula possible in Excel 2003? 1
How to Control a formula by a character in adjacent column on same 4
Set non-continuous PrintArea via Function / Name 0
Find first and last cells in range, return info beside 3
Count text then add results 2
Excel Need Countifs Formula Help 0
Cell reference in formula string displays abbreviated value 2

Back
Top