Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

difference

ResolvedVersion 365
Edited on Fri 14 Oct 2022, 11:03

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

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.