Subt_Col_EX_Forum.zipHi!
There are two columns with different values.
Column A negative values; Column B possitive.
The aim: to plus the values from column B with values from column A as mutch as it's possible, observing two constraints:
1) Column A values cannot go above 0;
2) Column B values cannot go under 0
See the file attached.
Thanks in advance!
Last edited by Arty_1; 11-25-2014 at 07:42 AM.
Regards
Arty
Try this formula:
=IF(AND(A1<0;B1>0)=TRUE;A1+B1;"ZERO VALUE")
D3=min(0,a3+b3)
e3=max(0,a3+b3)
try the above
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Nice formula bmouse.Originally Posted by bmouse
Arty_1 you can use "," in your excel if ";" doesn't worked as shown below
Please Login or Register to view this content.
Thanks nfsales! Just what I needed!
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks