Home › Functions › Compatibility › =GAMMAINV()
Compatibility Excel 2007 (Compatibility) ◉ 16 views

=GAMMAINV()

Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,...), then GAMMAINV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2021Excel 2021 for MacExcel 2019Excel 2019 for MacExcel 2016
=GAMMAINV(probability,alpha,beta)
Hover argument names in the table for details.
Output typeNumber
Popularity12 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =GAMMAINV() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download GAMMAINV.xlsx — Coming soon ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
probability Number Required The probability associated with the gamma distribution.
alpha Number Required A parameter to the distribution.
beta Number Required A parameter to the distribution. If beta = 1, GAMMAINV returns the standard gamma distribution.

▣ Examples

معکوس توزیع تجمعی گاما برای آرگومان‌های probability، alpha و beta در A2، A3 و A4 =GAMMAINV(A2,A3,A4)

✦ Tips

  • This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

⚠ Common Errors

#VALUE! If any argument is text, GAMMAINV returns the #VALUE! error value.
Fix: همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید.
#NUM! If probability < 0 or probability > 1, GAMMAINV returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMAINV returns the #NUM! error value.
Fix: Between 0 and 1
#N/A If the search has not converged after 100 iterations, the function returns the #N/A error value.
Fix: مقادیر ورودی را بررسی کنید یا با مقادیر probability متفاوت دوباره تلاش کنید.

⇄ Related Functions

=FORECAST() Predicts a future value based on a linear trend (the legacy FORECAST.LINEAR) =MODE() The MODE function returns the most frequently occurring, or repetitive, value in an array or range of data. =PERCENTILE() Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. If k is non-numeric, PERCENTILE returns the #VALUE! error value. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.