Circular ref help please?????

oddworld

Active Member
Joined
May 31, 2005
Messages
250
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Hi,

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

Forum statistics

Threads
1,214,276
Messages
6,118,625
Members
448,844
Latest member
Jayee04e

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top