Excel & Google Sheets
Generate formulas for spreadsheets
Generate Formula
Generated Formula
Enter your request above to generate a formula
Examples
Calculate the average of values in column A
=AVERAGE(A:A)Calculates the average of all values in column A
Find the maximum value in range B2:B10
=MAX(B2:B10)Returns the highest value in the specified range
Count how many cells in column C are not empty
=COUNTA(C:C)Counts non-empty cells in column C
Look up value from table using VLOOKUP
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Searches for a value in the first column of a table and returns a value in the same row from another column
Feedback & Feature Requests
We value your input! Please fill out the form below to share your thoughts and suggestions.
Having trouble with the form above?