if formula question
 

I am trying to use the following formula and it doesn't work for all my
tests. If the answer is false I want the value to return but not greater
than G7. Here is the formula =-if(A17(G4+G5+G7),0,min(A17-G7-(G4+G5),G7)).

if formula question
 

"it doesn't work" is not the most helpful of problem descriptions.

What input values do you have in those cells?
What result are you getting?
What result did you expect?
--
David Biddulph

"Theresa" wrote in message
...
I am trying to use the following formula and it doesn't work for all my
tests. If the answer is false I want the value to return but not greater
than G7. Here is the formula
=-if(A17(G4+G5+G7),0,min(A17-G7-(G4+G5),G7)).

if formula question
 

The formula entered does do what you,re looking to do. the value returned is
greater than G7?

"Theresa" wrote:

I am trying to use the following formula and it doesn't work for all my
tests. If the answer is false I want the value to return but not greater
than G7. Here is the formula =-if(A17(G4+G5+G7),0,min(A17-G7-(G4+G5),G7)).

if formula question
 

Is the leading minus on purpose to make the result positive?


Maybe you want something like this


=IF(A17(G4+G5+G7),0,MIN(-(A17-G7-(G4+G5)),G7))

otherwise explain what you are doing, what you expect the result to be etc.

--


Regards,


Peo Sjoblom

"Theresa" wrote in message
...
I am trying to use the following formula and it doesn't work for all my
tests. If the answer is false I want the value to return but not greater
than G7. Here is the formula
=-if(A17(G4+G5+G7),0,min(A17-G7-(G4+G5),G7)).