Hello macropod,
I'm sorry but the 2nd formula, which is the one I need, is not working when I try it (and I am using CTRL F9 to insert the brackets).:
{IF{REF Dropdown1 }= "No" {=D12*.0835} 0 \# "$,0.00;($,0.00)"}
I'm still using the '$#,##0.00' though, but I don't think that will affect the formula to not work.
When I try to test my document now, the cell with this formula doesn't register anything--no matter if I choose 'Yes' or 'No' from the dropdown in the cell just to the left of it. Can you think of why?
The other fields in the table have been added by going to Developer/Legacy Tools under 'Controls'/Text Form Field and dictated what Type, Text Format, Calculate on Exit, etc. in the Text Form Field Properties dialog box. Could this not be working b/c I've not added this form field like I have the other ones?
I would appreciate any further help. I'm so close to finishing this project. Could I fwd the table portion to you somehow?
Thank you very much,
derby46a
|