![]() |
|
#8
|
||||
|
||||
|
Quote:
{IF{REF Dropdown3 \* MERGEFORMAT }= "Yes" {SUM(ABOVE)*0.1 \# "$,0.00"} 0 \# "$,0.00"} Similarly, the second field's formula would become: {IF{REF Dropdown1 }= "No" {=D12*.0835} 0 \# "$,0.00;($,0.00)"} I note that, for the second example, you have switch expressions coded as '$#,##0.00'. This will add spaces between the $ symbol and the thousands separator for amounts < $100, but those spaces are unlikely to be much more than half the width as the digits they replace. If you need a separation between the $ symbol and the values, it is better to use a tab character, format the cell as left-aligned and use a right, or decimal, tab stop where needed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Detect a cell has un-approved change or not? | LongTTH | Excel Programming | 1 | 05-20-2012 02:22 AM |
how to change number in cell
|
ubns | Excel | 5 | 05-14-2012 04:21 PM |
| Link and change source for multiple tabs from excel to powerpoint | excel3 | PowerPoint | 1 | 01-19-2012 02:01 AM |
| CHange colour of footer if a cell changes to red | OTPM | Excel | 0 | 05-26-2011 07:15 AM |
| highlight cell after checkbox | flatk | Word | 0 | 01-25-2007 12:32 PM |