I am using Office 2003 on Windows XP.

I need a spreadsheet formula I can write into the sheet from code that would
use the following logic, but I'm stumped. I would like to do this using a
single formula because it is really for another user and their sheet
structure demands it:

IF G6 LIKE "*FUTURE*" Then E6 * N6 * 10000
IF G6 LIKE "*SWAP*" Then E6 * N6 * 2500
IF G6 NOT LIKE "*FUTURE*" NOR LIKE "*SWAP*" Then blank (i.e. "")

I know in place of "LIKE" I need to use "Search", but I can't crack the
logic. Could someone please post a solution?

Thanks much in advance.