D Denise Aug 18, 2009 #1 =([LAST YR USAGE]+[THIS YR USAGE])/2 I would like to round the answer to the next $5 level. What function do i use?
=([LAST YR USAGE]+[THIS YR USAGE])/2 I would like to round the answer to the next $5 level. What function do i use?
J John Spencer Aug 18, 2009 #2 You can try the following as long as the numbers are positive = -Int(-([LAST YR USAGE]+[THIS YR USAGE])/2 / 5) * 5 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County
You can try the following as long as the numbers are positive = -Int(-([LAST YR USAGE]+[THIS YR USAGE])/2 / 5) * 5 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County
D Denise Aug 18, 2009 #3 Works like a charm - ty much.. John Spencer said: You can try the following as long as the numbers are positive = -Int(-([LAST YR USAGE]+[THIS YR USAGE])/2 / 5) * 5 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County =([LAST YR USAGE]+[THIS YR USAGE])/2 I would like to round the answer to the next $5 level. What function do i use? Click to expand... Click to expand...
Works like a charm - ty much.. John Spencer said: You can try the following as long as the numbers are positive = -Int(-([LAST YR USAGE]+[THIS YR USAGE])/2 / 5) * 5 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County =([LAST YR USAGE]+[THIS YR USAGE])/2 I would like to round the answer to the next $5 level. What function do i use? Click to expand... Click to expand...
