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)).

"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)).

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)).

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)).