G
G
gladyshef2019-03-29 10:06:22
Spreadsheets
gladyshef, 2019-03-29 10:06:22

How to write a formula in Google spreadsheets to calculate a different percentage depending on the amount?

It is necessary that, depending on the number in cell A1, I could calculate % in cell B1 (But it changes on a scale depending on the number A1):
6% if <=250
7% if <=300
8% if <=350
9% if <=400
what should the formula look like?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2019-03-29
@gladyshef

5c9dc7bfaf244359624486.png
=ARRAYFORMULA(VLOOKUP(B10:B13;E2:F6;2;1))
Example https://docs.google.com/spreadsheets/d/1ehTUd_dP_A...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question