---
title: IFs
description: Make a logical comparisons between a value and what you expect
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# IFs

## Make a logical comparisons between a value and what you expect

***Function:***

Ifs(table = *string*, if_statement = {if = {col = *string*, logical_choice =*string*, value = *string*}, then = *string*}, else_value = *string*, new_col = *string*)

 

***Parameters:***

*Table: *Table name on which to perform function

*Ifs Statement*: Logical statement to evaluate, you can have as many of these as you need

- *Column:* Column to evaluate
-  *Logical Selection: *How to evaluate the column (ie. Equals, Greater than, Is before date...)
- *Value: *Value to evaluate based on the logical selection (ie X = Y)
- *Then: *Value to return if the above condition is met

*Else: *Value if non of the conditions above are met

*New Column Name:* Name for the column

 

***Examples:***

Ifs(table = Budget, if_statement = {if = {col = "Geo", logical_choice = "Equals", value = "USA", if_group_logic = "And", col = "Segment", logical_choice = "Equals", value = "Mid Market"}, then = "USA MM"}, else_value = "Small Business", new_col = "Ifs statement")