# Excel Nested IF formula help needed

1. ## 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 last value ( cell H4 ) = BUY then set value = Hold
Else
set value = Hold

Thank you for your help !

engine44  Register To Reply

2. ## Re: Excel Nested IF formula help needed

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 last value ( cell J4 ) = BUY then set value = Hold

Else
set value = Hold  Register To Reply

3. ## Re: Excel Nested IF formula help needed

Hello
try this one
However it doesn't seems to match some results of "Hold", as you told that if High Price > Target Selling Price then set value = SELL so it returns "Sell" but as per your example the results are "Hold"
Can you explain which criteria I am probably missing??
Regards  Register To Reply

4. ## Re: Excel Nested IF formula help needed

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 :

Re-attached the updated file.

Thank you ! this is a big help. regards
engine44  Register To Reply

5. ## Re: Excel Nested IF formula help needed

Cheers!  Register To Reply