Add multiple "if" formulas or make a short formula

[vishu]

I have A to J column that provides buy sell with targets with stop loss
In the cell, "J3 " shows whether the price is triggered or not now want. To add more formulas in the same cell which shows a target hit 1 2 3 and if price moves above 3 than out of range should display

Buy Sell Formula.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2	Magic Number	9.32	Entry	Ini.Tgt.	1st Tgt.	2nd Tgt.	3rd Tgt	Strict SL	Last Traded Price
3	578.00	Buy>	582.66	584.99	588.72	591.98	594.31	578.09	589	BUY
4		Sell<	573.34	571.01	567.28	564.02	561.69
Sheet1

Cell Formulas
Range	Formula
B2	B2	=C3-C4
D3	D3	=C3+(B2*0.25)
E3	E3	=C3+(B2*0.65)
F3	F3	=C3+B2
G3	G3	=C3+(B2*1.25)
H3	H3	=AVERAGE(C3:C4)+B2/100
D4	D4	=C4-(B2*0.25)
E4	E4	=C4-(B2*0.65)
F4	F4	=C4-B2
G4	G4	=C4-(B2*1.25)
J3	J3	=IF(A3<I3,IF(I3>C3,"BUY","B Near SL"),IF(I3<C4,"SELL","S Near SL"))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J3	Cell Value	contains "SELL"	text	YES
J3	Cell Value	contains "BUY"	text	YES
A1	Cell Value	="LONG"	text	YES
A1	Cell Value	="SHORT"	text	YES
C1	Cell Value	="LONG"	text	YES
C1	Cell Value	="SHORT"	text	YES

 

[SanjayGMusafir]

I have tested each condition individually - All are giving FALSE as result. Now you have to test and see what exact conditions you want to reflect a particular message and set Formula accordingly. I can't comment on conditions, I can only test validity of formula.

Best wishes

=IF(AND(N7<V6,V6>P6,V6>T6,V6>S6),"Buy Tgt 3 done",
IF(AND(N7<V6,V6>P6,V6>S6,V6>R6),"Buy Tgt 2 done",
IF(AND(N7<V6,V6>P6,V6>R6,V6>Q6),"Buy Tgt 1 done",
IF(AND(N7<V6,V6>P6,V6>Q6,V6>N7),"Buy Ini Tgt done",
IF(AND(N7<V6,V6>P6),"BUY",
IF(AND(U6<V6,U6>N7),"BUY WAIT",
IF(AND(N7<V6,V6>P6),"BUY",
IF(AND(U6<P7),"BUY SL HIT",
IF(AND(N7>V6,V6<P7,V6<T7,V6<S7),"Sell Tgt 3 done",
IF(AND(N7>V6,V6<P7,V6<S7,V6<R7),"Sell Tgt 2 done",
IF(AND(N7>V6,V6<P7,V6<R7,V6<Q7),"Sell Tgt 1",
IF(AND(N7>V6,V6<P7,V6<Q7,V6<N7),"Sell Ini Tgt done",
IF(AND(N7>V6,V6<P7),"SELL",
IF(AND(U6>V6,U6<N7),"SELL WAIT",
IF(AND(N7>V6,V6<P7),"SELL",
IF(U6<P7,"SELL SL HIT"))))))))))))))))

 

[SanjayGMusafir]

I have tested each condition individually - All are giving FALSE as result. Now you have to test and see what exact conditions you want to reflect a particular message and set Formula accordingly. I can't comment on conditions, I can only test validity of formula.

Best wishes

=IF(AND(N7<V6,V6>P6,V6>T6,V6>S6),"Buy Tgt 3 done",
IF(AND(N7<V6,V6>P6,V6>S6,V6>R6),"Buy Tgt 2 done",
IF(AND(N7<V6,V6>P6,V6>R6,V6>Q6),"Buy Tgt 1 done",
IF(AND(N7<V6,V6>P6,V6>Q6,V6>N7),"Buy Ini Tgt done",
IF(AND(N7<V6,V6>P6),"BUY",
IF(AND(U6<V6,U6>N7),"BUY WAIT",
IF(AND(N7<V6,V6>P6),"BUY",
IF(AND(U6<P7),"BUY SL HIT",
IF(AND(N7>V6,V6<P7,V6<T7,V6<S7),"Sell Tgt 3 done",
IF(AND(N7>V6,V6<P7,V6<S7,V6<R7),"Sell Tgt 2 done",
IF(AND(N7>V6,V6<P7,V6<R7,V6<Q7),"Sell Tgt 1",
IF(AND(N7>V6,V6<P7,V6<Q7,V6<N7),"Sell Ini Tgt done",
IF(AND(N7>V6,V6<P7),"SELL",
IF(AND(U6>V6,U6<N7),"SELL WAIT",
IF(AND(N7>V6,V6<P7),"SELL",
IF(U6<P7,"SELL SL HIT"))))))))))))))))

Best idea is to create a dummy data and manipulate data the way you want and test various conditions.

This way you will be able to test each condition that you want to have is working properly.

Best wishes

 

[vishu]

You do not need to wait for my approval. We do not lock threads here.

I am sorry was not aware of cross-posting and need to ask. this kind won't happen henceforth
below providing the link same query asked
IF AND formula error "FALSE"

 

[vishu]

Best idea is to create a dummy data and manipulate data the way you want and test various conditions.

This way you will be able to test that each condition that you want to have is working properly.

Best wishes

just want to try if any formula which works smoothly here. Not very keen to use other cells and thanks buddy, for helping hard.

 

[vishu]

Best idea is to create a dummy data and manipulate data the way you want and test various conditions.

This way you will be able to test each condition that you want to have is working properly.

Best wishessa

Sanjay ji please if you found any solution will be very helpful.

 

[SanjayGMusafir]

Sanjay ji please if you found any solution will be very helpful.

Vishu you have to create a Dummy data on another sheet and try what you want to achieve. I built the formula I gave you that way only - Making and checking every condition at a time. There can be no other way. Further, you are using Excel 2016 so have to work with the version limitations.