Adding a value to a cell that contains text

Closed

sabrina - Mar 2, 2016 at 05:12 PM
Blocked Profile - Mar 2, 2016 at 06:11 PM

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!!!

Adding a value to a cell that contains text
Count if cell contains number - Excel Forum
If cell contains date then return value - Excel Forum
Adding close friends story to highlights - Instagram Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum

1 response

Answer 1 / 1

Blocked Profile
Mar 2, 2016 at 06:11 PM

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!

Similar discussions

If a cell contains any text then add a value

Highlight cell if another cell contains specific text

If cell = date return yes or no.

Excel: If Date =, then enter a value

Excel "IF" function w/ date in test cell

Similar discussions

Subscribe To Our Newsletter!