New answers tagged

0 votes

Multiple IF Functions with Tick Boxes and Dates in Google Sheets

Use an ifs() formula in cell B2, like this: =to_date( ifs( not(isdate(A2)); iferror(1/0); C2 * D2 * E2; A2 + 6; C2 * D2; A2 + 2; C2; A2 + 1; true; iferror(1/0) ) ) See ...
  • 9,467

Top 50 recent answers are included