13% 0% 6% 100%: calculated from the 3rd and 4th rows
1/8 0/7 1/16 3/3: entered by operator
1 0 1 3: entered by operator
8 7 16 3: entered by operator

I have a spreadsheet with lots of cells like these. The top row
contains a formula that divides the numbers in the third and fourth
rows. The fraction in row 2 is entered by hand. The problem is that
the fraction is often not changed when updated numbers are entered.
The higher-ups who get this report have a very low tolerance for errors
made by other people. So, I am wondering if there is a way that I can
present the numbers in rows 3 & 4 as a fraction, still have them feed
the formula in row one, and get rid of row 2 altogether.

Any suggestions?

Mike


--
burnsbyrne


------------------------------------------------------------------------
burnsbyrne's Profile: http://www.excelforum.com/member.php...o&userid=22153
View this thread: http://www.excelforum.com/showthread...hreadid=390289