
FV function, 195
calculating investment value, 195-196
G
gain, calculating for stock, 19
gallons, converting from liters, 24
Gantt chart, creating, 265
GCD function, 184
determining greatest common
divisor, 184
Goal Seek, using as analysis tool,
311-312
greatest common divisor, determining,
184
gross price, calculating, 347
H
HLOOKUP function, 219
determining sales and costs for team,
219-220
determining sales for a particular day,
221
generating a list of dates for specific
month, 222
showing costs and sales for specific
day, 380-381
horizontal range, copying to vertical
range, 302-303
HOUR function, using to calculate with
100-minute hours, 121
hours,
converting to minutes, ...