Why functions in SQL when we already have Stored Procedures?

Question

When we have Functions & Procedures?

As Procedure returns single value and multiple values. so why we need a Function in SQL for returning single value?