sum a cell value over 75
 

Please help!!
Excel beginner! I need to build a formula that will add any remaining value
over 75 in a cell.

For example:
In cell A1 = 76.5
In cell A2 - I need a formula that will sum anything over 75 and enter 1.5
into cell A2.

Thanks in advance for everyone's help!!

sum a cell value over 75
 

For example:
In cell A1 = 76.5
In cell A2 - I need a formula that will sum anything over 75 and enter 1.5
into cell A2.

Perhaps, as a start .. try in A2: =IF(A175,1.5,"")
A2 will return 1.5 if A1 contains a number exceeding 75, otherwise A2 will
just appear empty ("") -- this is an assumed return which is not specified
above (you didn't say what you want in A2 if A1 doesn't contain a number
exceeding 75).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Beginner" wrote:
Please help!!
Excel beginner! I need to build a formula that will add any remaining value
over 75 in a cell.

For example:
In cell A1 = 76.5
In cell A2 - I need a formula that will sum anything over 75 and enter 1.5
into cell A2.

Thanks in advance for everyone's help!!

sum a cell value over 75
 

Max,

My interpretation is very different but then I have been wrong before. ;)

I think 1.5 is a variable i.e. it will change with A1. In this example, the difference between 76.5 and 75 is 1.5. So, my formula in A2 will be =A1-75. If A1 is <75, A2 will have a negative number.

Will stay tuned.

Epinn

"Max" wrote in message ...
For example:
In cell A1 = 76.5
In cell A2 - I need a formula that will sum anything over 75 and enter 1.5
into cell A2.

Perhaps, as a start .. try in A2: =IF(A175,1.5,"")
A2 will return 1.5 if A1 contains a number exceeding 75, otherwise A2 will
just appear empty ("") -- this is an assumed return which is not specified
above (you didn't say what you want in A2 if A1 doesn't contain a number
exceeding 75).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Beginner" wrote:
Please help!!
Excel beginner! I need to build a formula that will add any remaining value
over 75 in a cell.

For example:
In cell A1 = 76.5
In cell A2 - I need a formula that will sum anything over 75 and enter 1.5
into cell A2.

Thanks in advance for everyone's help!!

sum a cell value over 75
 

Perhaps a good point, was blind to this relation earlier <g:
I think 1.5 is a variable i.e. it will change with A1.
In this example, the difference between 76.5 and 75 is 1.5.

In that case, my revised hunch for the OP would be
to try instead in A2: =IF(A175,A1-75,A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Epinn" wrote:
Max,

My interpretation is very different but then I have been wrong before. ;)

I think 1.5 is a variable i.e. it will change with A1. In this example, the difference between 76.5 and 75 is 1.5. So, my formula in A2 will be =A1-75. If A1 is <75, A2 will have a negative number.

Will stay tuned.

Epinn

sum a cell value over 75
 

Maybe

=MAX(A1-75,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Beginner" wrote in message
...
Please help!!
Excel beginner! I need to build a formula that will add any remaining
value
over 75 in a cell.

For example:
In cell A1 = 76.5
In cell A2 - I need a formula that will sum anything over 75 and enter 1.5
into cell A2.

Thanks in advance for everyone's help!!

sum a cell value over 75
 

This has turned out to be a guessing game. :)

A couple of phrases from the request caught my eyes:

"...add any remaining value over 75..." and "...sum anything over 75..."

So, I think Bob's formula should take care of this. If it is a negative number, make it zero. This is great. Bob, I didn't know that I could use MAX( ) this way. The MS Excel Help didn't seem to talk about this. Wish there is BP Excel Help as well when I press F1. <bg Thank you, Bob. I can always learn something from you, be it something as complicated as SUMPRODUCT ( ) or something as simple as MAX ( ).

Have a good weekend.

Epinn

"Max" wrote in message ...
Perhaps a good point, was blind to this relation earlier <g:
I think 1.5 is a variable i.e. it will change with A1.
In this example, the difference between 76.5 and 75 is 1.5.

In that case, my revised hunch for the OP would be
to try instead in A2: =IF(A175,A1-75,A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Epinn" wrote:
Max,

My interpretation is very different but then I have been wrong before. ;)

I think 1.5 is a variable i.e. it will change with A1. In this example, the difference between 76.5 and 75 is 1.5. So, my formula in A2 will be =A1-75. If A1 is <75, A2 will have a negative number.

Will stay tuned.

Epinn

sum a cell value over 75
 

This worked perfectly!!

Thanks Max and Epinn for the help also!!

Yes the 1.5 is a variable and will change depending on the number of hours.


"Bob Phillips" wrote:

Maybe

=MAX(A1-75,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Beginner" wrote in message
...
Please help!!
Excel beginner! I need to build a formula that will add any remaining
value
over 75 in a cell.

For example:
In cell A1 = 76.5
In cell A2 - I need a formula that will sum anything over 75 and enter 1.5
into cell A2.

Thanks in advance for everyone's help!!

sum a cell value over 75
 

It's good that you did feedback further (Thanks for that!), otherwise guess
we'll never know what was it that you really wanted <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Beginner" wrote in message
...
This worked perfectly!!

Thanks Max and Epinn for the help also!!

Yes the 1.5 is a variable and will change depending on the number of
hours.