Yes, the intended effect of Viagra is to give you an erection. However, taking any erectile dysfunction medication will only be effective if sexually aroused.