# Using Excel formulas in Glide **URL:** \ **Category:** Ask for Help\ **Created:** [November 13, 2024, 6:43am UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867 "2024-11-13T06:43:13Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![RoyGarcia](https://avatars.discourse-cdn.com/v4/letter/r/fbc32d/32.png) [@RoyGarcia](https://community.glideapps.com/u/RoyGarcia)\ **Post date:** [November 13, 2024, 6:43am UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/1 "2024-11-13T06:43:13Z")
Hi friends, does anyone know how I can implement this Excel formula in a Glide database column? ![Captura de pantalla 2024-11-13 a la(s) 12.27.04 a.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/123760737193c353aae9c8d49a8b8e75faa2d703.png) ---
**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:** [November 13, 2024, 8:09am UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/2 "2024-11-13T08:09:50Z")
Hola Roy! Usa esta fórmula para hacerlo manualmente dentro de una **columna Math** : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01167d4a3b451be84c31728f6bcb20c4ea79a79e.png) Es importante mantener la consistencia en las unidades de tiempo para _r_ y _n_ usando preferiblemente la unidad de tiempo “_meses_”. Saludos! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 13, 2024, 11:36pm UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/3 "2024-11-13T23:36:29Z")
Looks like it’s the “PMT” formula. I did this the other day. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/fff2858635c3071fb754dbbd0eb20ebca4cc3dcf.png) ```auto -(L*(R/100/12))/(1-(1+(R/100/12))^-A) ``` L = “present value” R = “mortgage interest rate” (I have to divide by 100 and 12 here since I’m storing, let’s say, 7.5% annually as “7.5”) A = “amortization term (number of periods)” ---
**Author:** ![RoyGarcia](https://avatars.discourse-cdn.com/v4/letter/r/fbc32d/32.png) [@RoyGarcia](https://community.glideapps.com/u/RoyGarcia)\ **Post date:** [November 17, 2024, 10:44pm UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/4 "2024-11-17T22:44:36Z")
Hola @gvalero, te agradezco mucho por tu apoyo. He estado intentando aplicar la formula como me la compartes y si que no logro dar con el resultado correcto. Te comparto algunas capturas de pantalla, en donde si quito el “-” de la formula me da el mismo resultado que la cantidad del préstamo y si lo pongo, me da una cantidad fuera de lugar. ¿Qué crees que pueda estar haciendo mal? ![Captura de pantalla 2024-11-17 a la(s) 4.40.44 p.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d84df907d7142ec4b3a30b7ac7c31c27b2da38c.png) ![Captura de pantalla 2024-11-17 a la(s) 4.41.09 p.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/272dd2b05e4a8b0ac899623060e5cef1d855dab8.png) ![Captura de pantalla 2024-11-17 a la(s) 4.41.22 p.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c8aa722824f910913733ae1d8b768a913055363.png) ---
**Author:** ![RoyGarcia](https://avatars.discourse-cdn.com/v4/letter/r/fbc32d/32.png) [@RoyGarcia](https://community.glideapps.com/u/RoyGarcia)\ **Post date:** [November 17, 2024, 10:47pm UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/5 "2024-11-17T22:47:17Z")
![Captura de pantalla 2024-11-17 a la(s) 4.45.20 p.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94bd74f64cb70dc3f3210bec43c3b4495723841c.png) Hello @ThinhDinh thank you very much for your support. I am trying to apply the formula you share with me and I am not getting the expected result. what do you think I might be doing wrong? ---
**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:** [November 17, 2024, 11:12pm UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/6 "2024-11-17T23:12:42Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5ceeff137b5804e3d69c85874d464e43099694fd.jpeg) Hola de nuevo! Creo te falta un paréntesis en el denominador de la división. Allí lo dibujé como pude en mi imagen (hice lo mejor desde mi tlf 🥴). La “r” debe estar en función de los meses del año y ser un valor decimal puro, por ejemplo: - Si la tasa es del 24% anual, r = 24/100/12 =\> **0,02** Espero te sirva esta vez! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 17, 2024, 11:53pm UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/7 "2024-11-17T23:53:57Z")
Can you show us your inputs for L, R and A? ---
**Author:** ![RoyGarcia](https://avatars.discourse-cdn.com/v4/letter/r/fbc32d/32.png) [@RoyGarcia](https://community.glideapps.com/u/RoyGarcia)\ **Post date:** [November 19, 2024, 2:41am UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/8 "2024-11-19T02:41:52Z")
Hello, my problem was correctly placing the % of the interest rate in decimal. Thank you very much for the support, if you have a solution, I can get the correct result. See you soon. ---
**Author:** ![RoyGarcia](https://avatars.discourse-cdn.com/v4/letter/r/fbc32d/32.png) [@RoyGarcia](https://community.glideapps.com/u/RoyGarcia)\ **Post date:** [November 19, 2024, 2:45am UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/9 "2024-11-19T02:45:38Z")
Esto estuvo perfecto, muchas gracias, justo mi error fue en el uso del % en decimal, eso fue la solución y agregar los parentesis. Te agradezco mucho. Hasta luego. ---
**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:** [November 19, 2024, 12:28pm UTC](https://community.glideapps.com/t/using-excel-formulas-in-glide/77867/10 "2024-11-19T12:28:35Z")
Me alegro que te haya servido nuestra ayuda @RoyGarcia Para mejorar el sistema y las estadísticas, marca tu caso como “Solución” para cerrar este caso por favor. Saludos!