Previous Topic Next Topic

Salary difference from two years based in employee

Closed
Shivani - Mar 7, 2018 at 08:34 AM
 Blocked Profile - Mar 7, 2018 at 03:38 PM
Hello,

Hi sir/ madam
I have two sheets and in one sheet consists of 2007 year employees details ( I'd and salary) and second sheet also consists of same employees ids and salary s but some members are added to next year then how to find out the difference between the salary from 2008 to 2007 and comparison

1 response

Answer 1 / 1
Blocked Profile
Updated on Mar 7, 2018 at 03:38 PM
If the first year is on "Sheet1" cell A1, and the second year is on "Sheet2" cell A1 then the formula would be:

=(Sheet2!$A$1 - Sheet1!$A$1)

That would give you the difference between Sheet2 and Sheet1.

Have FUN!

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Name Values
brendanconlin -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses