Antoanela has attended:
Excel Advanced course
Excel Advanced course
Difference
I used VlookUp to see whether my rates are changed or not from the previous week and also if any new rates are added or not. I found that there are some changes in my data and also new prices added.
I want to find the change between two prices and if new prices are added I want to add it as "NEW" and highlight it in my change column.
Below is the example of what my result should be. I tried using IF and IF-OR functions but I am unable to return NEW in my first column.
Can you please help me out with this.
change 1 2
-10 409 419
-20 399 419
-10 569 579
NEW NEW 439
-70 839 909
-70 1139 1209
RE: Difference
Hello Antoanela,
Thank you for your question. A formula which works for me is:
=IF(K2="New","New",K2-L2)
This IF formula assumes that column K and L hold the amounts. If a cell in Column K says New instead of a value, the result will also say New. Otherwise, it will return the difference.
I hope this helps.
Kind regards
Marius Barnard
STL