M
M
mUchenik2020-08-11 10:26:48
excel
mUchenik, 2020-08-11 10:26:48

How to write a formula with a YES/NO function?

All the best, dear experts!
Please advise how I can implement this idea in Google Sheets:
Columns ABCD
Row 1
Cell A1 is equal to value 15
Cell B1 is equal to value "Yes" or "No"
Cell C1 is equal to value 5
Cell D1 is equal to the sum of A1+C1
The main condition is:
If B1 equals "Yes", then A1 is added to C1.
But if B1 is "NO", then nothing is added to A1.

Thank you.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
datka, 2020-08-11
@mUchenik

=IF(B1="ДА";A1+C1;A1)
5f324afcbbbb6704166983.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question