Yes. One way to think about this question (and many other health questions) is this way: "If I have the disease, what are the risks to me and/or others if I don't know?" For certain diseases, the consequences may be minimal (e.g. premature hair loss), or only affect the patient (e.g. diabetes). However, in the case of HIV, not knowing could put your health - and that of your loved ones - at serious risk.
The history of HIV/AIDS unfortunately gave this disease a negative social stigma. Because of the extremely high rate of death of this disease in the early 1980s, it was viewed as a death sentence (similar to "cancer"). Also, it was initially associated with certain lifestyles.
Fortunately, none of these conditions are true today. HIV affects all cultures, genders, sexual orientations, and social classes. In fact, there is serious debate in the medical community about making it a routine test - something done during a routine physical. In the near future, it may no longer need pretest and posttest counseling.
While you may be nervous while waiting for the test result, if negative, it will put a lot of your fears to rest.