Change cell reference mutliple sheets formula [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

I have 7 spreadsheets that I am currently using the IF formula for. These spreadsheets all have the same format so currently the formulas sits at:

=IF(Sheet1!C5="",Sheet2!C5,Sheet1!C5)

This is want I am trying to say, if Column C has one of the cells that is empty, then move to column C in the next sheet and so forth. The problem is sheet 2 does not start specificly with cell 'C5', instead, it references with the cell in the previous sheet.

Example:
=IF(Sheet1!C6="",Sheet2!C6,Sheet1!C6), all at C6's
=IF(Sheet1!C7="",Sheet2!C7,Sheet1!C7), all at C7's
=IF(Sheet1!C8="",Sheet2!C8,Sheet1!C8), all at C8's

I want each sheet to start at cell C5 no matter where the previous sheet cell ends off. When it finds a cell in column C that is empty, go to the next sheet starting at C5.

I hope I made sense.

Thanks in advance for helping.

Olivia

2 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
If sheet1 cell C5 is not empty then it will never go to Sheet2!C5 and will give the value of sheet1!C5 ..... make blank your sheet1!C5 then your formula will go onward ........ Just check and tell me if there is still problem .....

4
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4095 users have said thank you to us this month

how can i translate of 200.25 resulting to two hundred & 25/100
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
Just select the cell and then go to Format>Cell>Number>Fraction and on left side window select desired format .....