The absolute value in si... In this video we show how to get the absolute value in Excel using the ABS function - and 2 examples of why you may want to do this. Writing a function in Excel. When we enter functions into Excel, we use a special character to tell the program that what we are entering is a function and not a normal block of text: the equals sign (=). Whenever Excel sees the = sign at the beginning of the input to a cell, it recognizes that we are about to feed it a function. Jan 16, 2020 · Check the "Value Of" box, then type your target value into the text box next to "Value Of". For example, if your goal is to have $200 at the end of the month, you would type 200 into the text box. You can also check either the "Max" or "Min" box in order to prompt Solver to determine the absolute maximum or minimum value.