on 10-20-2015 12:35 PM
Hi,
Can any one please explain this formula .
( stock BT 180 to 365 < 0 ) * ( GR till 180 days >= 0 ) * ( stock BT 180 to 365 + GR till 180 days )
+ ( stock BT 180 to 365 >= 0 ) * ( GR till 180days >= 0 ) * GR till 180 days
+ ( stock BT 180 to 365 < 0 ) * ( GR till 180 days < 0 ) * stock BT 180 to 365 + 0.
Please convert the formula in general words i am not able to get the logic built in it .
Thanks and Regards,
Gopichand.
Hi Gopi,
should be like this
IF stock BT 180 to 365 < 0 AND GR till 180 days >= 0
RESULT = stock BT 180 to 365 + GR till 180 days
ELSEIF
stock BT 180 to 365 >= 0 AND GR till 180days >=0
RESULT = GR Till 180 days
ELSEIF
stock BT 180 to 365 <0 AND GR till 180 days <0
RESULT = stock BT 180 to 365
ELSE
RESULT= 0.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thank for responding Jyothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.