# Arrayformula calcular %

bom dia

alguem teria uma array formula para calcular a preço custo mais porcentagem = preço de venda do produto

Are you looking for a discount price, or to increase the price for sale?

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.

quando eu coloco uma % no caso 10% fica assim ai ele nao calcula direiro coluna da planilha esta formatada para %

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”.

[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

1 Like

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/margin

https://www.omnicalculator.com/finance/margin#margin-vs-markup