---
title: If(s) Statement
description: If(s) statement that will perform logical checks on data table
---

[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)

# If(s) Statement

## If(s) statement that will perform logical checks on data table

***Function:***

Ifs(table = string, new_col = string, if_statement = string)

***Parameters:***

*Table: *Table name on which to perform function

*New Column Name:* New name for the created column

*Ifs Statement:* Logical statement to perform on table. When using column names in the statement format them like the following - ['column name'] 

 

***Examples:***

***Ifs(table = Budget5567, new_col = Updated Stage, if_statement =   
if ['Stage'] == 'Closed Won':  
return 'Won'  
if ['Stage'] == 'Lost':  
return 'Lost'  
else:  
return 'Do not care')***