# Excel slope and number of cells

**URL:** <https://community.glideapps.com/t/excel-slope-and-number-of-cells/45017>\
**Category:** Ask for Help\
**Created:** [July 22, 2022, 8:46am UTC](https://community.glideapps.com/t/excel-slope-and-number-of-cells/45017 "2022-07-22T08:46:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rafael\_Gonzalez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_gonzalez/32/18512_2.png) [@Rafael\_Gonzalez](https://community.glideapps.com/u/Rafael_Gonzalez)\
**Post date:** [July 22, 2022, 8:46am UTC](https://community.glideapps.com/t/excel-slope-and-number-of-cells/45017/1 "2022-07-22T08:46:50Z")

</div>

I am absolutely loving the addition of the excel formula!

I have a couple of questions, hopefully someone can help me. I have a formula that I needs 6 input cells, is there a way to do this? Currently it only has 5 cells, but I imagine there is a way around that.

Secondly I need to be able to use the SLOPE function which isn’t currently supported, does anyone know how I can go about adding that to the supported functions? I did see the github link, but I’m not very code savvy.

The formula I need to do is =SLOPE(A1:A3,A4:A6)

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [July 22, 2022, 11:09pm UTC](https://community.glideapps.com/t/excel-slope-and-number-of-cells/45017/2 "2022-07-22T23:09:44Z")

</div>

> [@Rafael\_Gonzalez](#):
>
> Secondly I need to be able to use the SLOPE function which isn’t currently supported, does anyone know how I can go about adding that to the supported functions? I did see the github link, but I’m not very code savvy.

Hola!

Right, maybe SLOPE() function is not supported but you can do calculations by using Math column, I think something like this is enough for you if you need to use/know **only 2 coordinates** on the line.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a3da4bf90763512cce878f630ceafcdb82ce72ca.png)

and get all this…  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/9084c7c7ded092dc683256c00e330ebe4f7299e6.png)

Instead, if you need to use an array or several data points, the scenario is different. You will have to use this formula:  
. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/26a1404b9199f68cd56ea9f66fb9ced34fc786e9.png)

and create other Math columns manually to recreate what formula shows. This [link](https://exceljet.net/excel-functions/excel-slope-function) can help you with all this.

I hope this helps you.

Saludos!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 25, 2022, 8:41am UTC](https://community.glideapps.com/t/excel-slope-and-number-of-cells/45017/3 "2022-07-25T08:41:08Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.