The value return 0 |General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi,

Can you please help me to figure work out what wrong here with this formula below which I suppose  :

1.  If the value in cell [@Signal] is one of the specified signals and the value in cell [@Ready2] is empty, the value in cell [@Entry] will be copied to cell [@Ready2].
2. If the value in cell [@Signal] is one of the specified signals and the value in cell [@Ready2] is not empty, the value in cell [@Ready2] will remain unchanged, even if the value in cell [@Signal] changes.
3. If the value in cell [@Signal] is not one of the specified signals, the value in cell [@Ready2] will remain unchanged, even if the value in cell [@Signal] changes.
4. The value in cell [@Ready2] will remain unchanged, even if the value in cell [@Entry] changes.
5. [@Entry] is live share price I pull in  and I am using Microsoft 365 which maybe the problem. The formula below works  If [@Entry] is the normal column with manually typing in. 
6. [@Ready2] return 0 if [@Entry] is live share price

The formula:

=IF(OR([@Signal]="S BUY 1",[@Signal]="S BUY 2",[@Signal]="S BUY 3",[@Signal]=1,[@Signal]="BUY"),IF(AND([@Ready2]="",[@Entry]<>"",ISNUMBER([@Entry])),[@Entry],[@Ready2]),IF([@Ready2]="", "",[@Ready2]))

Thanks for your helps