I'm trying to do a nested IF statement but also include an IF(SEARCH) in the same formula.
<tbody>
A
B
C
$15
$1000
?
$25
$100
~$30
$75
</tbody>
For example, Column A will occasionally include ~ for dollar amounts that are estimates. In Column C I'm trying to solve for the following...