Related:

- Adding a value to a cell that contains text
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum

## 1 response

In the next column(c), you test for the actual value with the GREAT AND WONDERFUL =IF().

So the next column would contain =IF(b1="FREE",0.00,b1)

See if that works for ya! Very simple!