Stock Profolio Formula

[wilsonmpw]

Hi people,

I am trying to write a stock price formula that identifies when a stoc
price is 3% higher than the previous stock price.

I am learning Excel so the formula I wrote might be far off...

=if(d1>d2*3%,"yes","no")

Can you help?

Thanks
Mik

 

[Andy B]

Hi

Try:
=IF(D1>D2*1.03,"yes","no")

 

[wilsonmpw]

Hi Andy,

Thanks very much that worked

 

[Andy B]

Thanks for the feedback!