0
   

Positive/negative calculation in exel

 
 
Reply Wed 20 Feb, 2013 07:52 am
I need a formula that calculates the following:
the range i have is from -4.75 to 4.75. I put in 6 numbers random negative and positive but when one of the numbers reach the -4.75 or 4.75 it should bring it back lower but have to ad it up to the other side of the zero line.
example:

I have the numbers 2.45, -3.67 ,0.34, -1.22, 4.75, 3.12

now the 4.75 has to go back but what you go back on that number adds up the negative numbers. so if I go from 4.75 to 3.75 that one point adds up at -3.67 and -1.22 and makes it -4.67 and -2.22.

the -3.67 is still with in range.

who can help me with making a formula?

thanks
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 1,170 • Replies: 1
No top replies

 
jespah
 
  2  
Reply Wed 20 Feb, 2013 08:24 am
@peterhuijts,
"when one of the numbers reach the -4.75 or 4.75 it should bring it back lower but have to ad it up to the other side of the zero line."

I can't figure out what that means. Are you trying make sure that the calculation doesn't go over or under the range? E. g. if a number less than -4.75 (say, -5) is included, it's supposed to be changed to -4.75, and then the calculation is performed?
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » Positive/negative calculation in exel
Copyright © 2020 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 02/24/2020 at 09:44:22