Google-sheets – Need to create a formula with the operand in a different cell in Google Sheets

formulasgoogle sheetsgoogle-sheets-query

For eg .

Existing formula which works
Query(A4:K,"Select A Where I = > 0.3")

should be replaced by
Query(A4:K,"Select A Where I = "&N1&"")

with cell N1 containing value '>0.3'

Appreciate any help

= > is not a valid operator the following operators are valid <=, <, >, >=, =, !=, <>

Your first code should look like this

Query(A4:K,"Select A Where I >= 0.3")

Your second code would look like this (Assuming N1 contains >0.3)

Query(A4:K,"Select A Where I "&N1)

I eventually used:

=COUNTIF(indirect(D2&"!$C$4:$C$102"),B5)

Formulas can contain other formulas: if(condition, formula1, formula2). In your example, one can do

=IF( IF(S2<232,0,7), IF(S2<232,0,7), COUNT(L2,M2,N2,O2,P2,Q2,R2) )

so that when the output of the first formula is True, the If gets used, and otherwise COUNT gets used.

The above can be simplified to

=IF(S2<232, 7, COUNT(L2,M2,N2,O2,P2,Q2,R2) )

but I included the more complicated version to show the general idea.