Hi,
Trying to put together a macro that would look at column C and based on the way that it is being summed up (A-B vs B-A) use the value to make a column consistent. Please see the attached workbook.
please advise... Ty
Reverse Sum formula Macro.xlsm
Hi,
Not sure what you mean by consistent. If you mean you want all column D values to have the same positive sign then use
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Originally Posted by Richard Buttrey
Hi,
Not sure what you mean by consistent. If you mean you want all column D values to have the same positive sign then use
Formula:Please Login or Register to view this content.
For example....
if you take 5 - 3 you'll get 2
if you take 3 - 5 you'll get -2
So what I want to do is compare 2 & -2 , RECOGNIZE that they are opposite and flip the formula in the right direction...
Maybe:
Please Login or Register to view this content.
Hi,
What do YOU mean by 'flip the formula in the right direction'.
If you tell us the values of the results you expect in the various cells we'll have a better idea.
As I say if you want them all the same sign, i.e. all positive then use the ABS() function I gave you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks