: Is it possible to get or make a Excel function  to identify  the
: active  sheet and to be used as the following example.
:
: In a sheet  named "RESULTS" in the cell  A1 I write: if
: (actsheet()="CityBank"; 1,23; 1,75)

This works in my locale. You will probably need to change the
IF() function syntax to work with your number system.

In cell:
=IF(ActiveSheetName("CityBank"),1.23,1.75)

In module:
Function ActiveSheetName(Name As String)

ActiveSheetName = False
If Application.ActiveSheet.Name = Name Then ActiveSheetName = True

End Function