Re: $$Excel-Macros$$ Need Help in IF formula

2018-02-14 Thread Rabindra Thapa
*Regards,* *For quick responds click here for Message * On Mon, Feb 12, 2018 at 9:31 AM, Ruchin Gupta wrote: > I have a table where data changes continously (stock market data). I want > to apply IF formula. please understand with given example. > > A1 = 10 > B1 = 20 > C1 = 5 > D1 = where i w

$$Excel-Macros$$ Need Help in IF formula

2018-02-11 Thread Ruchin Gupta
I have a table where data changes continously (stock market data). I want to apply IF formula. please understand with given example. A1 = 10 B1 = 20 C1 = 5 D1 = where i want to put formula. Now the value of A1 keeps changing. I want that if A1>B1, it shld write "Buy" in D1 cell. Similarly if A1