• ## Other - General

There is no available content in category Other - General
• ### Recent Forum Posts

#### 2010 index match

My table is as such:
Column B: Names
Column E: Remainder
Column K: Criteria is True or False.

I need a formula that searches...

ohhaykfrankk Today, 12:58 AM

#### Countif visible cells only

Hello
I don't think that COUNTIF itself will work, but it can be done using SUMPRODUCT, if that helps.
See my attachment....

Hercules1946 Yesterday, 11:48 PM

#### If statements

thank you - the two formulas you provided are outside of my scope unless they are explained teacher to student
as a caveat to this - how do you...

coachclint Yesterday, 11:00 PM

#### If statements

I was also going to suggest:

=IF(G14="ns",-10,IF(ISBLANK(G14),0,LOOKUP(G15-\$B14,{-9.99999E+307,4,6,8},{5,2,1,-5})))

...

NBVC Yesterday, 09:33 PM

#### If statements

What are all those AND(...)s doing in there?; they seem at first sight to be superfluous.
You could also try the likes of:
=IF(G14="ns",-10,IF(ISBLANK(G14),0,INDEX({5;2;1;-5},MATCH(G14-\$B14-0.00001,{-9999;3;5;7}))))...

p45cal Yesterday, 09:19 PM