Related:
- Adding a value to a cell that contains text
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- Count if cell contains number - Excel Forum
1 reply
ok, so this easy solution just needs two columns. In one column(b) you have cost...so some have 1.00 and some have free.
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!
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!