I need a text wildcard in IF Function

Closed
Anthony - Jan 14, 2015 at 03:39 PM
I would like to use a formula that does this...
I placed the cursor in I20
If G20 is a number, multiply it by $I$4. and put in a in I20
If G20 is a text copy the text to I20.
=IF(G20="*","*",+G20*$I$4)
The * doesn't work as a wildcard.
The "text" doesn't work as a wildcard for text.
Does anyone know what will work?