PLEASE HELP FINDING TRENDS

S

syed

Please can someone tell tell me how to correct this one.

=IF(G11 =-1#AND#G10^ =-1,"SELL",IF(G11 = 1#ANDG10^ =1,"BUY"," "))
 
F

Frank Kabel

Hi
do you mean
=IF(AND(G11 =-1,G10 =-1),"SELL",IF(AND(G11 = 1,G10 =1),"BUY",""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Formula with AND added (I think) 3
Find cell for today 3
I created a Formula, OK, but can't get the results in the right ce 8
formula help 0
Help with MAX / MIN formula (I think) 13
formula to alert if expiring within 40 days 2
Macro to Select text from a point given to a specific word 2
Missing data when using TREND function 0

Top