Home » Forums » Open Source Learning Center » Question and Answer

Subtract the first value from (down to up) when the value > “0”

Submitted by Sandrahan on 20 May, 2012 - 16:02

Dear Excel experts,

How I can tell excel to “subtract” the first value from (down to up) when the value > “0”
For more details please find the attached excel

Thanks for support

AttachmentSize
help.xlsx10.24 KB
‹ Script won't run in Excel 2010 Filtering issue ›
»
Vishesh's picture

This formula should do Put

Submitted by Vishesh on 20 May, 2012 - 16:47.

This formula should do

Put this in D2
=IF(A2=0,0, A2-MAX($A$1:A1))

»

Thanks Vishesh it's

Submitted by Sandrahan on 20 May, 2012 - 16:51.

Thanks Vishesh it's working

thanks for your great help

»