> For the complete documentation index, see [llms.txt](https://docs.valq.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.valq.com/model/formula-functions/logical-functions/if.md). # IF An IF statement returns a value depending on whether the condition that is being evaluated is TRUE or FALSE. ### Syntax IF(logical\_test, value\_if\_true, value\_if\_false) ### Arguments

Arguments	Data Type	Condition
logical_test	Text / Number	The condition to be evaluated.
value_if_true	Node reference / Number	The value to be returned if the condition is met.
value_if_false	Node reference / Number	The value to be returned if the condition is not met.

### Return Value Either *value\_if\_true* or *value\_if\_false.* ### Remarks 1. Returns Blank when the formula is misspelled. 2. The specified node should contain Numerical data. 3. The IF function returns error in any of the following cases: * *value\_if\_false* argument is missing. * The argument *value\_if\_true* or *value\_if\_false* are not of numeric data type. * Not using appropriate operator in *logical\_test*. ### Example Consider the **Revenue** and **Cost of Goods Sold** nodes to follow the trend as shown below.

Parameter	Jan	Feb	Mar	Apr	May	Jun
Revenue	100	124	137	0	23	45
Cost of Goods Sold	25	25	25	25	25	25

Now, a new node **Gross Profit Margin** can be computed using the IF function. Gross Profit Margin is calculated as (Revenue-Cost of Goods Sold)/Revenue. In case Revenue has period value of 0, Gross Profit Margin should return 0. To achieve this, the following formula should be written in the \[Gross Profit Margin] node: **`IF`****`(`****`[Revenue]`****`==0,0%,(`****`[Revenue]`****`-`****`[Cost of Goods Sold]`****`)/`****`[Revenue]`****`)`** ### Result

Parameter	Jan	Feb	Mar	Apr	May	Jun
Gross Profit Margin	75%	80%	82%	0%	-9%	44%

As you can see from the above table, if the logical test condition (Revenue==0) is True, it returns 0, i.e. the gross profit margin is 0 and if the logical test condition is False (Revenue is a non-zero number), it calculates the Gross Profit Margin from the formula and returns it. {% hint style="info" %} Use **SWITCH** function instead of nesting multiple IF functions. {% endhint %} --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.valq.com/model/formula-functions/logical-functions/if.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.