If there is a decrease between these 2 cells, then populate the difference.

[LBrain]

Sheet 1

2001 2002 2003
john 8 9 8
joe 7 8 9
kyle 8 8 6.5

I have duplicated this sheet, and would now like the cells below the years to be populated with the decrease on the duplicated sheet.
I want it to look like this vvvv


2001 2002 2003
john - - 1
joe - - -
kyle - - 1.5

Is there a formula for the second sheet that can help me with this?
Thanks!

 

[Leo Skywalker]

Sheet2, Cell B2:

=IFERROR(IF(Sheet1!A2-Sheet1!B2>0,Sheet1!A2-Sheet1!B2,0),0)

 

[LBrain]

now what if there are blank cells between these numbers?

2001 2002 2003 2004
john 8 9 8
joe 7 6
kyle 7 7 8 9

 

[johnmpl]

Hi!

Another option could be:

=MAX(;N(Sheet1!A2)-Sheet1!B2)

Blessings!

 

[Leo Skywalker]

If there are blanks, they will be treated as zeroes.

2001 2002 2003 2004
john 8 9 8
joe 7 6
kyle 7 7 8 9

will return:
2001 2002 2003 2004

john - - 1 8
joe - 1 6 -
kyle - - - -

If you'd rather have empty cells, then use:

Sheet2, Cell B2:
=IF(ISBLANK(Sheet1!B2),"",IFERROR(IF(Sheet1!A2-Sheet1!B2>0,Sheet1!A2-Sheet1!B2,0),0))​

​

 

[Leo Skywalker]

With John's option:

Sheet2, Cell B2:
=IF(ISBLANK(Sheet1!B2),"",MAX(,N(Sheet1!A2)-Sheet1!B2))