| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
