# Removing STYLE() breaks the formula [closed]

Hi all, some times ago I received a precious help from this community regarding the use of STYLE(). Well, now Im facing some problems when sheets is read on dropbox or with other suites so I decided to remove the STYLE() option. This works for me like a violin :)

**=IF(C30="","",IF(COUNTIF(C6:C26,"MW|SA|PA|MA|PB|MB")=C30,"0"&T(STYLE("Good")),COUNTIF(C6:C26,"MW|SA|PA|MA|PB|MB")-C30&T(STYLE("Bad"))))**

Then I modified it this way

**=IF(C30="","",IF(COUNTIF(C6:C24,"MW|SA|PA|MA|PB|MB")=C30,"",COUNTIF(C6:C24,"MW|SA|PA|MA|PB|MB")-**C30**))**

Now the cell shows the value in C30, (the one marked italic). I mean, if I change the reference (eg C29) in the first COUNTIF still see the value of C30 in the second COUNTIF. Which brings to my problem: I always see the value of the second C30.

Any suggestion? Thank you in advance

You mean the result is the negated value of C30 if the COUNTIF() result is 0.

If the result is zero I see a correct blank cell, otherwise I always see the value of C30. It seems the formula doesnt take care of the first part of the formula

That doesn't make sense as the result basically is COUNTIF()-C30

Maybe you formatted it to not display the minus sign.