Formula reference
Every Hunch formula, with its Google Sheets and Excel spelling, arguments, what it returns and what it costs. Blank cells and repeated texts are free, and answers are cached for six hours.
| Google Sheets | Excel | Returns | Credits |
|---|---|---|---|
=HUNCH(text, question) | =HUNCH.ASK | Probability of yes, 0 to 1 | 1 per row |
=HUNCHPICK(text, options) | =HUNCH.PICK | One option from your list | 1 per row |
=HUNCHSCORE(text, question, levels) | =HUNCH.SCORE | Position on your levels, 0 to n−1 | 1 per row |
=HUNCHMULTI(text, questions) | =HUNCH.MULTI | One probability per question | 1 per row per question |
=HUNCHBALANCE() | =HUNCH.BALANCE() | Credits left on your key | Free |
Pages
- HUNCH: the probability that the answer is yes HUNCH
- HUNCHPICK: one option from your list HUNCHPICK
- HUNCHSCORE: a position on your own scale HUNCHSCORE
- HUNCHMULTI: several questions, one read of the text HUNCHMULTI
- Errors and cell messages Errors
- How Hunch works How it works
- Credits, pricing and limits Credits and pricing
Run it on your own column
Copy the template (or use the Excel add-in), paste your key, point the formula at your data. Every formula here has its Excel spelling underneath. 100 rows free to start, then $29 for 5,000 rows. Credits never expire and there is no subscription.