CODE EXAMPLE FOR TYPESCRIPT

excel if value in range then return value

// Format will be: =IF(CellRef<Lowerbound & CellRef>Upperbound, Value, Else)
=IF(A1<10 & A1>20, "value", "")