# Arrayformula calcular % **URL:** \ **Category:** Ask for Help\ **Created:** [October 17, 2019, 12:44pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237 "2019-10-17T12:44:48Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 17, 2019, 12:44pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/1 "2019-10-17T12:44:48Z")
bom dia alguem teria uma array formula para calcular a preço custo mais porcentagem = preço de venda do produto ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 17, 2019, 12:50pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/2 "2019-10-17T12:50:33Z")
Are you looking for a discount price, or to increase the price for sale? ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 17, 2019, 12:51pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/3 "2019-10-17T12:51:51Z")
![VENDAS](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b41fc650c7572f46e5aa9af29bce0138572f4056.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 17, 2019, 1:19pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/4 "2019-10-17T13:19:35Z")
If you are using the percent symbol (%), use this: `(D2:D*(E2:E+1))` If you are not using the percent symbol (%), use this: `(D2:D*((E2:E/100)+1))` Your example shows that you are using D3 and E3 when they should be D2 and E2. ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 17, 2019, 1:31pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/5 "2019-10-17T13:31:05Z")
> [@Jeff\_Hager](#): > > (D2:D\*(E2:E+1)) quando eu coloco uma % no caso 10% fica assim ai ele nao calcula direiro coluna da planilha esta formatada para % ![VENDAS](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b11b68c3d8ad1372c6cf14b392a48c485356163b.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 17, 2019, 1:40pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/6 "2019-10-17T13:40:51Z")
I think it’s because the column is formatted in the sheet as a percent column, so Google multiplies the value you enter by 100. It would work if you entered 0.10 in your glide form instead. It might be better to enter percentage without % and use the second formula. You will have to change the formatting of the column in the sheet to “number” instead of “percent”. ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 17, 2019, 1:52pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/7 "2019-10-17T13:52:34Z")
[quote=“Jeff\_Hager, post:4, topic:1237”] (D2:D\*((E2:E/100)+1)) [/quote USEI A SEGUNDA FORMULA E TIREI A FORMATACAO % DEU CERTO OBRIGADO ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 17, 2019, 2:41pm UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/8 "2019-10-17T14:41:08Z")
I found these two links interesting. There is a difference between Markup, which is what my formula calculates, vs Margin, which is what you were calculating with your formula. It’s an interesting read. Hopefully it translates well for you. [https://www.omnicalculator.com/finance/markup](https://www.omnicalculator.com/finance/markup) [https://www.omnicalculator.com/finance/margin](https://www.omnicalculator.com/finance/margin) [https://www.omnicalculator.com/finance/margin#margin-vs-markup](https://www.omnicalculator.com/finance/margin#margin-vs-markup) ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 18, 2019, 3:02am UTC](https://community.glideapps.com/t/arrayformula-calcular/1237/9 "2019-10-18T03:02:25Z")
Ok muito obrigado pelas ajudas