Excel conditional formatting

Closed
kstar234
Posts
2
Registration date
Friday June 6, 2014
Status
Member
Last seen
June 7, 2014
- Jun 6, 2014 at 12:19 AM
kstar234
Posts
2
Registration date
Friday June 6, 2014
Status
Member
Last seen
June 7, 2014
- Jun 7, 2014 at 01:03 PM
I have a worksheet that contains a row of payments per month....I want to include in a separate cell the amount of payments that are over $60 per month. Not the total but the excess of each payment over 60, i.e, if one payment is 75, I want 15 to be added to the amount of over-payments.

How do I do this?

3 replies

Blocked Profile
Jun 6, 2014 at 12:46 PM
AM I missing something? Are all payments over $60. If so, then just subtract 60 from your cell and viola. Like =A1-60. If cell A1 has 110, the cell with the formula would return 50.

Is that too simple?
0
No, not all payments are over 60 so yes, you are missing something.
0
Blocked Profile
Jun 7, 2014 at 10:13 AM
OK well, I guess you are the only one that can give more details to the problem. Can you show us what the data looks like on the sheet so that we can get a better idea of the problem then, because I have oversimplified it based on the problem description.

What determines on over payment? How are you qualifying whether the payment received is an over payment?

"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
0
kstar234
Posts
2
Registration date
Friday June 6, 2014
Status
Member
Last seen
June 7, 2014

Jun 7, 2014 at 01:03 PM


Hope this helps.
0