Syntax: Applying IF to a cell range in Excel -


i've been trying write formula summarise in 1 cell presence/ absence of values in different range of of cells in excel

so in 1 table , worksheet, wrote

=if(b1:f1=1,1,0) formula 1

which supposed mean

if of values in cells b1:f1 equal 1, note 1, otherwise not 0.

but somehow syntax isn't working.

i've applied "" , ; , brackets right left , centre, no avail.

i'm pretty sure done before , pretty simple when hit upon right synstax, how , fell through colander brain today :-?

additionally want ask formula apply condition output cell =if (a1 = value n or values, 1, 0) formula2 column has numerically coded ordinal values 0-9, aexample of teh 1 conditions might of values 1, 2 or 9 in column, should produce 1 in result cell in formula 1 , 2 written.

so result cell contain somelike =formula1_or_formula2_contain_certain_values, 1, 0) formula 3 systax of formulas 2 , 3 awol, write demonostrate formulae intended purposes.

the easiest way make first formula this:

=if(sum(b1:e1)>0,1,0) 

no arrays, no problems :)


Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -