Previous Topic Next Topic

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?
Related:

3 responses

Answer 1 / 3
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
kstar234
Jun 6, 2014 at 10:13 PM
No, not all payments are over 60 so yes, you are missing something.
0
Answer 2 / 3
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
Answer 3 / 3
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses