Related:
- Adding a value to a cell that contains text
- Count if cell contains number - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
1 response
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!