LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JZip
 
Posts: n/a
Default positive integer?

this is probably a dumb question, but i can't seem to figure out what
function would give me a return of a positive integer whether or not the
result of the equation is pos or neg. in other words, i am producing a data
series that is the slope of a trail (y2-y1)/(x2-x1) where y is elevation in
feet and x is distance in feet. the result of this equation can either
positive or negative depending onwhether the trail is ascending or descending
for that stretch, but i only want the results in positive integers. how is
that done?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying ranges iart Excel Discussion (Misc queries) 15 September 10th 05 02:02 PM
Highlighting positive and negative changes Dave Excel Discussion (Misc queries) 1 December 27th 04 10:46 PM
highlighting positive or negative change Dave Excel Discussion (Misc queries) 2 December 27th 04 01:28 PM
How can I change the position/format for all data labels in a ser. PearlBeast Charts and Charting in Excel 3 December 7th 04 08:07 PM
adding only positive numbers Jacob Excel Discussion (Misc queries) 2 November 30th 04 12:24 AM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"