Search
 
SCRIPT & CODE EXAMPLE
 

EXCEL

google sheets if

# Basic syntax:
=IF(condition, outcome_if_true, outcome_if_false)

# Note, the default setup for IF in Google Sheets is an IF ELSE

# Example usage:
=IF(A1 = "this text", "Houston, we have a match", 0)
# This returns "Houston, we have a match" if cell A1 is "this text", 
#	otherwise, it returns the number 0
Comment

google shets if

IF(A2 = "foo","A2 is foo")

IF(A2,"A2 was true","A2 was false")

IF(TRUE,4,5)
Comment

google sheets ifs

IFS(A1>90, "A", A1>80, "B", A1>70, "C")
Comment

PREVIOUS NEXT
Code Example
Excel :: excel get number of column 
Excel :: excel paste into multiple columns 
Excel :: excel or function 
Excel :: Time and date maths in Excel 
Excel :: google sheets filter cells that match 
Perl :: perl until loop 
Perl :: perl $ @ % 
Perl :: difference between @ and $ in perl 
Perl :: how to initialize an array 
Pascal :: pascal try catch finally 
Pascal :: case of pascal 
Powershell :: call function powershell 
Gdscript :: godot get root node 
Clojure :: how to use clojure cond 
Lisp :: random choice from list of strings in emacs lisp 
Assembly :: sqlalchemy filter date today 
Assembly :: wget output filename 
Assembly :: sort in assembly pcspim 
Javascript :: jquery vslidation remove spaces from input 
Javascript :: week days array in javascrpt 
Javascript :: jquery redirect 
Javascript :: Javascript run code after page load 
Javascript :: react native reset cache 
Javascript :: moment get today, tomorrow, yesterday 
Javascript :: detect browser javascript 
Javascript :: javascript code to edit webpage 
Javascript :: react native rotate 
Javascript :: javascript loop through class elements 
Javascript :: js find object length 
Javascript :: javascript for loop over dictionary 
ADD CONTENT
Topic
Content
Source link
Name
2+6 =