circular reference

  • Thread starter Thread starter qsm
  • Start date Start date
Q

qsm

This is what I'm trying to do and I can't seem to get a circula
reference to work. I want to enter a numerical weight value into
cell. I then want the cell to convert that number to a % based on th
sample size and display the result in the original cell. So if I hav
my sample size of 100 grams in cell A1 and I enter my defect weight o
10 grams in cell B1 then I want cell B1 to calculate and display as
percentage. Can I do this or is there a simpler way that I am missing
I don't really want to do calculation in another cell as I am tryin
to create a form. Any suggestions
 
You would need a macro to do what you describe. Why not the easy wa
...

In C1 entre formula :-
=B1/A1
and format as percentage
 
Back
Top