Correct an error in a complex data or formula
To solve faulty results and values:
Click Data > Goal Seek.
Enter required target cell and the cell that gives you a varying result and not the result you were expecting.
3. Both the target and variant cells should be formula cells for Goal Seek to work.
4. Click OK to arrive at the required value at the variant cell.
Related Articles
Data Types in Formula Fields
Data type is the kind of data that can be held and stored while evaluating an expression. Data types are the defined set of values and the allowable operations on those values. They represent either the function, argument, return value or the ...Data types in Formula Fields
Data type is the kind of data that can be held and stored while evaluating an expression. Data types are the defined set of values and the allowable operations on those values. They represent either the function, argument, return value or the ...Name a formula
To name a formula: Select the range of cells that contain the formula. Select Insert > Define Name. Enter a new name for your formula in the Add New Name data field. Click Add. You can also view the other user generated formulas that have been named ...Datatypes in Formula Fields
A data type is the kind of data that can be held and stored while evaluating an expression. Data types are the defined set of values and the allowable operations on those values. They represent either the function, argument, or return value of the ...Creating Formula Fields
Formula fields are used to calculate different types of values, including numeric values, text values, date values, etc. Formula fields and their resulting return value have certain data types associated with them and there are specific operators ...