Adding a value to a cell that contains text
Closed
Hello,
Can someone please help me? I want my cell to have the word FREE written in it BUT I also want that cell to represent 0.00$ when I add it to a formula. So my client see that it's free but at the same time I am able to calculate how much they truly have saved.
Thank you so much!!!
Can someone please help me? I want my cell to have the word FREE written in it BUT I also want that cell to represent 0.00$ when I add it to a formula. So my client see that it's free but at the same time I am able to calculate how much they truly have saved.
Thank you so much!!!
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 conditional formatting if cell contains specific text - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel 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!