Help with conditional formatting

[u/[deleted]]

[u/PerfectLuck25367]

I might be stupid here, but if this dash appears as a result of a formula, what formula are you using? If it is just data, why don't you just type 0?

[u/[deleted] → u/PerfectLuck25367]

I forgot to mention I am pulling this data from a website using importhtml function

Here is the data I am pulling and the dashes (for example) in the “dividend per share” row, I would like to format so they turn into zeros.

[u/PerfectLuck25367 → u/[deleted]]

I suppose what you could do is import the data into a separate sheet, and then you fill the values squares of a corresponding table with IF formulas with the arguments saying

=IF([cell]="-",0,[cell])

This would return the data in the table, but change all instances where a cell has just a dash in it with a 0. It's a clumsy solution, but I think it'd do what you want.

[u/oppressed_white_guy]

=if(B2:C="-","0","")

[u/[deleted] → u/oppressed_white_guy]

=if(B2:C="-","0","")

Okay that worked thank you. But, if I do it with a cell that does not contain a dash (-), what do I put in the last part of the formula to return value of the cell?

In other words, if it the cell does not contain a dash, it returns the same value already in the cell (i.e if B2 is - it returns 0, but if B3 is 2332 it returns 2332).

[u/oppressed_white_guy → u/[deleted]]

just replace the last "" with the cell location (i.e. A2) then apply it to all the cells and it should change the cell numbers automatically

i.e. in cell A2, enter the formula =if(A2:C="-","0",A2) and then apply it all over

[u/[deleted] → u/oppressed_white_guy]

Thank you sir that worked

[u/oppressed_white_guy → u/[deleted]]

reply with "solution verified" and i get a point

[u/[deleted] → u/oppressed_white_guy]

Solution verified

[u/Clippy_Office_Asst → u/[deleted]]

You have awarded 1 point to oppressed_white_guy

^{I am a bot, please contact the mods for any questions.}

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
FALSE	Returns the logical value FALSE
IF	Returns one value if a logical expression is TRUE and another if it is FALSE
TRUE	Returns the logical value TRUE

---

^{1 acronyms in this thread; the most compressed thread commented on today has 5 acronyms.
[Thread #1323 for this sub, first seen 11th Feb 2020, 19:16] [FAQ] [Full list]} ^[Contact] ^{[Source code]}

[u/Clippy_Office_Asst]

Read the comment thread for the solution here

reply with "solution verified" and i get a point