Кількість балів 25. Використовуючи фільтрацію відібрати дані із списку за наступними
критеріями:
1. Зробити вибірку по продажу автомобілів марки BMW.
2. Вибірку автомобілів, які були продані продавцем Дацко у
листопаді 2010 р.
А. в
D E
G
1
Облік проданих фірмою автомобілів
2
не
Назва Ціна $ Кількість Вартість Продавець Дата
3 запису
4
1 BMW
995 mm 4380 000 Дацко 14.11.10
5 2 Opel
$100 00
5 500 000 Діденко 25.11.10
6
3 Fiat
390 00 45360 0 Верес
17 12 10
7 4 BMW
S95
3 285 00 Дацко 18.12 10
8 5 Opel
$100 000
5 500 000 Горій 18.12.10
6 Fiat
590 000 3 $270 000 Дацко 25.12 10
10 B|Daewoo0
S80 00 10 000 000 Горій 17.12.10
11 9|Daew00
S00 00
6 S400 000 Діденко 14.11.10
12 10 Lexus LS $104 00
2 5200 000 Верес 25.12 10
13 11 Toyota Sequoia $88 00
$264 000 Діденко 14.11.10
Результати відбору та область критеріїв для використання
розширеного фільтру подати у вигляді таблиці.

Ваша формула полностью рабочая, не могу представить, почему в Вашем файле он выдает ошибку. В моём файле можете подставить свою формулу и убедиться в этом.

Предлагаю свой вариант:

=ЕСЛИ(ИЛИ(B2>$D$9;C2="Да");B2-B2*$D$8;B2)

Объяснение:

=ЕСЛИ - проверяет, выполняется ли условие, и возвращает одно значение, если оно выполняется, и другое значение, если нет

ИЛИ() - проверяет, имеет ли хотя бы один из аргументов значение ИСТИНА, и возвращает значение ИСТИНА или ЛОЖЬ. Значение ЛОЖЬ возвращается только в том случае, если все аргументы имеют значение ЛОЖЬ.

Прикрепляю готовый файл :)

am Zhilin Andrey. Andrey is my name and Zhilin is my surname. I am seventeen years old. I want to tell you a few words about my family. My family is not large. I have got mother, father and grandmother. There are four of us in the family.

First of all some words about my parents. My mother is a teacher of biology. She works in a school. She likes her profession. She is a good-looking woman with brown hair. She is 44 but she looks much younger.

My father is programmer. He is forty-six. My father often sings and when we are at home and have some free time I play guitar and we sing together. He is also handy with many things. When he was small he liked to take everything to pieces. My grandmother told me a story that once my father tried to repair their kitchen clock but without success. They had to give it to a repairman. But it happened a long time ago. Now he can fix almost everything.

My parents have been married for 18 years. They have much in common, but they have different views on music, books, and films. For example my father likes horror films and my mother likes soap operas. My father is fond of tennis. My mother doesn't go in for sports.

My parents are hard working people. My mother keeps house and takes care of my father and me. She is very good at cooking. My grandmother is a pensioner. She lives with us and helps to run the house. She is fond of knitting.

I want to become a student. I'd like to learn foreign languages. I always try to be in a good mood.

We have got a lot of relatives.