Understand a Spreadsheet and Design Formulas

1. 내용 입력하기

아래 값은 예시입니다. 내 내용으로 바꾸세요. 저장되거나 전송되지 않습니다.

2. 전체 프롬프트 복사

Complete the task using these inputs. Headers: [Headers]; Requirement: [Requirement]. First confirm the column types and software version, then give a small fictional sample clearly marked as a demo. Explain each argument of the recommended formula, give tests for blanks, amounts stored as text, and date boundaries, and provide an alternative PivotTable workflow; don't guess real data that wasn't provided. Structure the output as: understanding and assumptions, ready-to-use content, information I need to confirm, and next steps. Use clear, short sentences and avoid empty slogans; if key input is missing, ask at most three specific questions instead of filling gaps with guesses. Finally, check each item against my purpose and state clearly which results still need human review.

Complete the task using these inputs. Headers: [Headers]; Requirement: [Requirement]. First confirm the column types and software version, then give a small fictional sample clearly marked as a demo. Explain each argument of the recommended formula, give tests for blanks, amounts stored as text, and date boundaries, and provide an alternative PivotTable workflow; don't guess real data that wasn't provided. Structure the output as: understanding and assumptions, ready-to-use content, information I need to confirm, and next steps. Use clear, short sentences and avoid empty slogans; if key input is missing, ask at most three specific questions instead of filling gaps with guesses. Finally, check each item against my purpose and state clearly which results still need human review.

3. 결과 확인하기

Check formula ranges, date boundaries, and error-value handling. Verify names, numbers, and qualifiers from the input.

마음에 들지 않으면 변수를 하나씩 바꿔 이전 결과와 비교해 보세요.