How to make a formula in Google Sheets?

Question

Google Sheets

Hello everyone, I need help with formulas, I searched on the internet, either I didn’t search well, or it’s impossible to do this.

The question is as follows.

There is a table where only the amount of the cost and the amount of the advance are entered manually . The debt column, of course, automatically calculates the debt (cost minus the advance). And now the most interesting thing

, depending on the type of answer chosen, in the " Payment of the debt " column

, a number should automatically appear in the " money in work" column. selected, it costs only the advance figure. Can anyone help, is there a solution?

Answer 1

=ifs(D3="";B3;D3="NO";B3;D3="YES";B3+C3)