Ваша формула полностью рабочая, не могу представить, почему в Вашем файле он выдает ошибку. В моём файле можете подставить свою формулу и убедиться в этом.
Предлагаю свой вариант:
=ЕСЛИ(ИЛИ(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.
Ваша формула полностью рабочая, не могу представить, почему в Вашем файле он выдает ошибку. В моём файле можете подставить свою формулу и убедиться в этом.
Предлагаю свой вариант:
=ЕСЛИ(ИЛИ(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.