# Set variable using calculations

**URL:** https://www.finalbuilder.com/forums/t/set-variable-using-calculations/1566
**Category:** Discussion
**Created:** [August 17, 2010, 8:45am UTC](https://www.finalbuilder.com/forums/t/set-variable-using-calculations/1566 "2010-08-17T08:45:37Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![cliverichardson](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/c/82dd89/32.png) [@cliverichardson](https://www.finalbuilder.com/forums/u/cliverichardson)
#### Post date: [August 17, 2010, 8:45am UTC](https://www.finalbuilder.com/forums/t/set-variable-using-calculations/1566/1 "2010-08-17T08:45:37Z")

</div>

I'm sure it can be done but...

I want to set a variable based on a calculation involving another variable.&nbsp; I've tried using the 'set variable' action but can't get it to work.&nbsp;

Example using Excel functions...

Var1 = Ceiling(Var2 / 4, 1)

How can I do calculations like this in FinalBuilder and what would be the equivalent of the 'Ceiling' function?

&nbsp;

Regards,

Clive

---

<div class="post-metadata">

### Author: ![cliverichardson](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/c/82dd89/32.png) [@cliverichardson](https://www.finalbuilder.com/forums/u/cliverichardson)
#### Post date: [August 17, 2010, 3:39am UTC](https://www.finalbuilder.com/forums/t/set-variable-using-calculations/1566/2 "2010-08-17T03:39:56Z")

</div>

It’s ok. I found a way to do it using VBScript. In the BeforeAction…   
  
 Var1= int(Var2 / 4 + 1)   
  
 Clive