Open the Excel software on your desktop and open the Excel spreadsheet that contains the function you want to edit. Click the "VBA" button in the "Developer" tab or ribbon. Your VBA code opens.

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set.