Removing STYLE() breaks the formula

English
, ,
#1

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 :slight_smile:

=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

#2

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

#3

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

#4

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

Maybe you formatted it to not display the minus sign.

#5

As your COUNTIF() uses regular expressions in the Criteria make sure that regular expressions are enabled under Tools → Options → Calc → Calculate.

#6

And as you mention “problems when sheets is read on dropbox or with other suites” that probably won’t work at all because other suites don’t support regular expressions.

#7

Oh my…!!! My brain stopped to work. You are right. Sorry
The “problem” is the cause of this (no comment) thread. Should I start another question or we can gon on here?
Eventually how can I mark this as solved?

#8

Please, if the answer solves the question click :heavy_check_mark:.

#9

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.