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

X

xmdv2020-05-14 10:26:49

How to insert a row into an existing excel file using OpenXmlSDK? 1Reply

N

Nikolay Romanov2018-03-29 12:55:25

Cell multiplicity setting? 1Reply

V

Vladimir Kuzin2021-07-22 16:13:38

How to implement automatic filling of cells in excel? 1Reply

A

Andrey PINEAPPLE2018-03-30 19:19:28

Need help with building a chart in ms excel? 2Reply

M

Maxwell1342018-03-31 14:27:11

Excel how to move to a new line? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question