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