things to remember goal seek is based on the dependent and independent cells. ![]() The tutorial explains how to use goal seek in excel 2016, 20 to get the formula result you want by changing an input value. find the perfect course for you! the tutorial explains how to use goal seek in excel 2016, 20 to get the formula result you want by changing an input value. in the to value box, type the formula result that you want. its may be 5 multiply by 10 or 5 multiply by 20. ![]() for example if the answer is 100 and first number is 5 the what is the second number. this technique use when we are dealing with large number of datasheet. goal seek is different technique that use to find out the ambiguous number or which we are not sure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |