How to write such a condition in Excel?

A

A

Alexey Nikolaev2016-02-13 21:00:59

excel

Alexey Nikolaev, 2016-02-13 21:00:59

How to write such a condition in Excel?

There is a column A and B.
You need the following:
A > 150,000, then B = A * 0.97
A > 250,000, then B = A * 0.94
A > 350,000, then B = A * 0.92

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexey S., 2016-02-13
@Winsik

=IF(A1>350000,A1*0.92, IF(A1>250000, A1*0.94, IF(A1>150000, A1*0.97, "less than 150000" )))

Similar questions

T

tridevil2017-05-24 12:53:03

How to export tables from .sql to excel? 3Reply

S

sbh2015-06-11 09:31:47

How to put a list of excel sheets on top below the formula bar? 2Reply

D

Denis Kotov2021-04-27 03:07:33

Where is the best place to transfer documents? 2Reply

P

Petr Volkhanov2015-06-15 14:01:11

How to remove all unnecessary characters from a phone number in Excel? 3Reply

A

Alexey FRZ2017-06-13 16:38:50

FoxPro 2.0. How to display cells? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question