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
Bookmarks