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
Related Tags
google-sheets-dates × 294google-sheets × 287
formulas × 110
google-sheets-arrayformula × 65
google-sheets-query × 48
google-sheets-timestamp × 24
conditional-formatting × 22
google-apps-script × 15
vlookup × 13
date × 13
importrange × 8
formatting × 7
google-sheets-charts × 7
google-sheets-cell-format × 7
regex × 5
text-formatting × 5
data-validation × 4
google-drive × 3
google × 3
google-sheets-custom-function × 3
google-finance × 3
google-sheets-data-validation × 3
google-apps × 2
google-forms × 2
google-sheets-arrays × 2