Thank you, macropod. Sorry for the delayed response. I unlocked the document and saw the formula behind the fields and I was trying to change it to my dropdown box which uses Yes and No vs. wingdings.
When you press ALT+F9 your document shows the code:
IF{REF Dropdown3 \* MERGEFORMAT }={QUOTE 254} {SUM(ABOVE)*0.1 \# "$,0.00"} 0 \# "$,0.00"
I tried to make my code look similar but w/ a Yes/No dropdown but it doesn't work. Can you help fix what is wrong? (My formula is different b/c it asks if client is tax exempt, so "No" means the tax needs to be calculated--and I took out the MERGEFORMAT switch):
IF{REF Dropdown1 }={QUOTE No} {PRODUCT (D12,.0835) \# "$#,##0.00;($#,##0.00)"} 0 \# "$,0.00"
I've tried {QUOTE "No"} or just "No", or No without quotations, any variety you can think of and I get Syntax Error. My dropdown defaults to No. On some of these variations I've tried the "Yes" option works and the adjacent cell will change to $0.00 like it should. I would appreciate you checking where I am wrong.
Thank you so much for your help so far!
derby46a
|