LinkBack URL
About LinkBacks
I'm looking for a formula that will automatically make B1 zero, when A2 becomes negative
Price(A1): 66.33
Profit(A2): -1.38
Price(B1): 67.64
Formula for B1: 67.91+(A2*20%)
Formula for a negative value...
I'm looking for a formula that will automatically make B1 zero, when A2 becomes negative
Price(A1): 66.33
Profit(A2): -1.38
Price(B1): 67.64
Formula for B1: 67.91+(A2*20%)
Last edited by clogistics; 12-07-2015 at 03:05 AM.
yet present which formula you have in B1
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
You can use the IF CONDITION to force a zero as shown below
Regards
Please Login or Register to view this content.
e4excel
Formula for B1: 67.91+(A2*20%)
try below
B1: 67.91+(a2>0)*(A2*20%)
pr
B1: 67.91+max(0,A2*20%)
Both the formulas are resulting to the 67.91 value.Originally Posted by nflsales
Are you saying that if A2 is negative then B1 is 0 i.e. we ignore the 67.91 in your example
=IF(A2<0,0,67.91+(A2*20%) ???
same with formula above.
This formula worked perfect. Thanks!
Thanks for all the help, everybody.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks