LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 74
Default Finding Cell that changes from a Positive to a Negitive number

I am looking for a function that will look threw either columes or rows and
find the cell that changes from a positive number to a negitive number. This
location will always change and once this cell is found I need to used it in
a function to check for linearity. I have looked thew the help and forum and
haven't really found anything that might work. Any help with possible
functions would be great.
 
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
Coloring cells based on positive or negitive numbers Florida Richard Excel Discussion (Misc queries) 2 November 2nd 07 05:29 PM
adding cells with positive and negitive nos. George Sibley New Users to Excel 2 October 15th 06 03:38 PM
How can I get a defalt of a negitive number for a cell? Doug Excel Discussion (Misc queries) 1 May 11th 06 06:38 PM
How do I change numbers from positive to negitive Debi Excel Worksheet Functions 2 October 11th 05 06:09 PM
Making a cell Negitive only hw Excel Discussion (Misc queries) 3 May 23rd 05 11:12 PM


All times are GMT +1. The time now is 09:05 AM.

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"