Basically need to know what to put in formula to enter a value based on any text being entered into another.
B1 = formula goes here - will return a value of ".50" if any text is entered into A1
A1 = cell to check for any text
If no text is entered into A1, then B1 will remain blank.
Bookmarks