New answers tagged google-sheets-dates
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