Quote:
|
I was trying to change it to my dropdown box which uses Yes and No
|
In the first example cited, the field's formula would become:
{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.