intradayteam
New Member
- Joined
- Feb 15, 2010
- Messages
- 29
I worked out a formula
If A2 is "BUY" then it uses below formula
and IF A2 is "SELL" then it uses below formula
I want both formulas combined in one cell. I am worried about file size as my sheet has huge data in it. I am not in favour of using VBA as i dont have much knowledge about that.
As far as i searched, Maximum 7 IFs are allowed in each cell formula.
Pls help. If possible try to solve the issue with Formula only (no vba).
Thanks a lot.
If A2 is "BUY" then it uses below formula
Code:
=IF(ISBLANK(G2),"",IF(G2>F2,"Rocked",IF(AND(G2<=F2,G2>=E2),"Tgt Done",IF(AND(G2<E2,G2>C2),"Small Profit",IF(G2=C2,"Exit at Cost",IF(AND(G2<C2,G2>D2),"Exit in Loss",IF(G2<=D2,"SL Taken","")))))))
and IF A2 is "SELL" then it uses below formula
Code:
=IF(ISBLANK(G2),"",IF(G2<F2,"Rocked",IF(AND(G2>=F2,G2<=E2),"Tgt Done",IF(AND(G2>E2,G2<C2),"Small Profit",IF(G2=C2,"Exit at Cost",IF(AND(G2>C2,G2<D2),"Exit in Loss",IF(G2>=D2,"SL Taken","")))))))
I want both formulas combined in one cell. I am worried about file size as my sheet has huge data in it. I am not in favour of using VBA as i dont have much knowledge about that.
As far as i searched, Maximum 7 IFs are allowed in each cell formula.
Pls help. If possible try to solve the issue with Formula only (no vba).
Thanks a lot.