Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Last Figure
Hello Programmers, Example: I have a list of figures ranging from A1:A12. These cell contain formulas. If I have currency values in A1:A5, A:6 down to A:12 will have $0.00 because those cells haven't been updated yet. How do I display the last figure in the list in cell B1 (which in thi case would be in A5); Without the $0's showing up as a value? Then a A6 updates, and it's the last value in the list, then that's what shown in B1. Thanks, EMo -- EMo ----------------------------------------------------------------------- EMoe's Profile: http://www.excelforum.com/member.php...fo&userid=2318 View this thread: http://www.excelforum.com/showthread.php?threadid=47458 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
Change a specific figure i.e 0:00 and 24:00 to display as "MIDT" | Excel Discussion (Misc queries) | |||
Can't figure it out . . . | Excel Worksheet Functions | |||
To Display a figure while excel is ready to GO! | Excel Programming | |||
Can't figure it out | Excel Programming |