excel - Google sheets: Case statement or ifelse formula to modify a cell's value based on the value of another cell? -


  1. based on validation, if a1 = 20, b1 = 5.
  2. based on formula, b2 = b1.

except, want b2 = b1 + d1, if c1 = true.

my question is: how make formula 1 cell (b2) equals sum of 2 cells (b1,d1) in event third cell (c1) has true value? if false, want (b2) equal sum of 1 cell (b1).

so in b2:

=b1+if(c1="true",d1,0) 

if c1 true can shortened to:

=b1+if(c1,d1,0) 

enter image description here


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -