What does 0 mean and what is its effect in various condition?
For example : When I got the formula =A1-40+IF(A1>40;STYLE("RedText");0), I
was told “The STYLE function always returns 0, so the formula is
mathematically
equal to A1-40+0” What is effect of the 0 at the end of the formula?
For example if “Negative numbers red” is selected (is checked) when
formatting cells, 0:[RED]-0 appears in the Format code box.
For example I was told “Enter something like this in the format code field:
0"%" This will just add the % character right after the number, but the
number will still act as an ordinary number.”
Also when entering the O, under different conditions, Is the 0 a zero or a
capital letter?
