Formula Help


S

sross002

I would like to better explain my issue. I have Office Professional 2003
Windows.

In my ledger I have a threshold of $50 for associates to spend. Once that
threshold is reached whatever they spend after that is doubled.

for instance:
A B
1 WEEK 1 $50
2 WEEK 2 $10
3 WEEK 3 $5
4 SUBTOTAL $65
5 TOTAL $80

As you can see the person assciated with column 'B' went over the threshold
in week 1. So week 2 is doubled to $20 and week 3 is doubled to $10. The
Total should then read $80 instead of $65.

Can someone help me with a formula for: B5 so that if $50 is reached to
double every transaction after it is reached.

Thanks in advance,
Steve
 
Ad

Advertisements

F

FSt1

hi
try this
=IF(SUM(B2:B4)>50,(SUM(B2:B4)-50)*2+50,SUM(B2:B4))
adjust to suit

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top