Circular ref help please?????

oddworld

Board Regular
Joined
May 31, 2005
Messages
248
Hi all my boss has just shown me his spreadsheet that he is trying to complete. the problem is that he has used data from other sheets buy cutting and pasting into his new sheet and has come up with a circular reference. i will try and explain:
His sheet current reads
a1 is data manaully inputted
b1 =C1/A1
c1 =A1*B1

My question is can i make c1 formula on read the value in b1 and not the cell reference, any assisatance would be appreciated.

Cheers odd
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

The above calculation make no sense to me. Can you explain what you want to achieve?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,111
Messages
5,570,257
Members
412,313
Latest member
pauloalex
Top