Hi All,
I am trying to write IF statement to return a value based on the combination of a number of cells contents.
A B C D
15M L50 1HR L50 4HR L50 Daily L50
Sell Zone Sell Zone Sell Zone Sell Zone
If all 4 cells say Sell Zone I want to return - All ALIGNED
If 15M, 1HR and 4HR say Sell Zone I want to return - 15M, 1HR and 4HR aligned
If 15M and 1 HR say Sell Zone I want to return - 15M and 1HR aligned
So far I have this:
=IF(B2=A2"15M and 1HR Aligned",IF(C2=B2,"1HR AND 4 HOUR ALIGNED",IF(B3, C3, D3=A,"ALL ALIGN")))
Which really isn't there, but I am not sure where to start to change things.
Any of you excel wizards able to help? Bug thanks upfront for anyone who takes the time to help
Bookmarks