mysql> DELIMITER // 
mysql> CREATE FUNCTION CalculatePrice( Preis REAL , Marge REAL ) RETURNS REAL 
    -> BEGIN 
    -> DECLARE CalculatedPrice REAL; 
    -> SET CalculatedPrice = ROUND( (Preis + Marge)*1.076*20,0)/20; 
    -> RETURN CalculatedPrice; 
    -> END 
    -> // 
Query OK, 0 rows affected (0.09 sec) 
 
mysql> DELIMITER ; 
mysql> SHOW CREATE FUNCTION  CalculatePrice; 
+----------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 
| Function       | sql_mode | Create Function                                                                                                                                                                                                                    | 
+----------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 
| CalculatePrice |          | CREATE DEFINER=`root`@`localhost` FUNCTION `CalculatePrice`( Preis REAL , Marge REAL ) RETURNS double 
BEGIN 
DECLARE CalculatedPrice REAL; 
SET CalculatedPrice = ROUND( (Preis + Marge)*1.076*20,0)/20; 
RETURN CalculatedPrice; 
END | 
+----------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 
1 row in set (0.00 sec) 
 
mysql> select CalculatePrice(100,20); 
+------------------------+ 
| CalculatePrice(100,20) | 
+------------------------+ 
|                  129.1 | 
+------------------------+ 
1 row in set (0.02 sec) 
 
mysql>