Excel Nested IF formula help needed

Hello,

I am having some difficulties with the multiple Excel IF formula that contains a number of criteria. Basically, the formula is required to place different text values based on various conditions that I have defined.

Enclosed is a small sample file. The formula that needs to be created should be in column J but because I keep encountering error messages I have entered manually the expected values based on the criterion. Below is the business logic.

Column H Excel formula ( cell H5 as example )
IF Interim signal = SELL then set value = Exit Alert

Either (i) IF High Price > Target Selling Price then set value = SELL
OR (ii) IF Low Price < Base Price then set value = SELL

IF last value ( cell H4 ) = Exit Alert then
IF Open Price > Target Selling Price then set value = SELL
IF Interim Signal = BUY then set value = BUY
IF last value ( cell H4 ) = BUY then set value = Hold
Else
set value = Hold

Thank you for your help !

engine44

Sorry for the typing error. It should be column J. ( instead of H )

Column J Excel formula ( cell J5 as example )
IF Interim signal = SELL then set value = Exit Alert

Either (i) IF High Price > Target Selling Price then set value = SELL
OR (ii) IF Low Price < Base Price then set value = SELL

IF last value ( cell J4 ) = Exit Alert then
IF Open Price > Target Selling Price then set value = SELL
IF Interim Signal = BUY then set value = BUY

IF last value ( cell J4 ) = BUY then set value = Hold

Else
set value = Hold

Hello sourabhg98,

I have missed out 2 other conditions which have now been added to your formula above. The complete nested IF formula should be :

=IF(I2="SELL","EXIT ALERT",IF(I2="Buy","BUY",IF(J1="Exit Alert",IF(B2>G2,"Sell","Exit Pending"),IF(J1="Buy","Hold",IF(J1="SELL","Hold",IF(J1="Hold","Hold",IF(OR(C2>G2,D2<H2),"SELL","Hold")))))))

Re-attached the updated file.

Thank you ! this is a big help.

regards
engine44