Running totals:at the bottom.

Hi,

Can anyone please tell me what formulas I would need to enter into the '-75%' and '25%' columns on the attached sheet.

Basically, I want to enter an amount in the amount column, then I want 75% deducted in the '-75%' column, and then the other 25% to be showing in the '25%' column.

And for each column, a running total at the bottom.

I'm sorry if their is an tutorial on this site already, I did have a look but couldn't find it.

Many thanks,

Wiggo

Edit: Couldn't find a way to attach file.

Originally Posted by wiggo

Hi,

Can anyone please tell me what formulas I would need to enter into the '-75%' and '25%' columns on the attached sheet.

.... snipped

Edit: Couldn't find a way to attach file.

In which case it's a little difficult to advise

Please go below your post an use the Attach files section.

Rgds

In E2:

=C2*0.75
or...
=IF(C2="","",C2*0.75)


In G2:
=C2-E2
or...
=IF(C2="","",C2-E2)

In E42:
=SUM(E2:E41)

Copy that cell to G42.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)