If function problem

Closed
PJ - Sep 1, 2009 at 12:14 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Sep 1, 2009 at 05:09 PM
Hello,
I am working with a commission/pay problem in Excel. I need to add up negative numbers from previous months/rows but only if they have not been paid off by a positive number month/row. For example say I have two negative months of $(300.00) but then I have a good month/row following the two negative months of $3000.00. So that column would equal 3000.00 - 600.00. Can someone please help me.
Thanks PJ

2 responses

Blocked Profile
Sep 1, 2009 at 01:29 PM
I am sorry but am a bit confused in trying to understand what you are tryin to do, but if you want to make difference between positive and negative value use

If X >0 then
'do something
'for positive values
end if

If X < 0 then
' do something
' for negative values
end if
0
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Sep 1, 2009 at 05:09 PM
i'm with deepbreathe, you need to be more specific in your goal.
0