How to write such a condition in Excel?

A

Alexey Nikolaev2016-02-13 21:00:59

excel

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

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

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

R

random_object2018-09-27 12:29:26

V

Vadim Solovyov2018-10-05 11:52:04

L

LastGeneral2020-08-26 15:14:39

V

Vadim Solovyov2018-10-08 20:41:06

K

KTG2021-12-15 05:23:05

Didn't find what you were looking for?