| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Show two rows as a fraction?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Rows Button | Excel Discussion (Misc queries) | |||
| Hide and show Rows | Excel Discussion (Misc queries) | |||
| Do not show rows with no values in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
