if formula question

  • Thread starter Thread starter Theresa
  • Start date Start date
T

Theresa

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

constant in formulas 3
to create a formula by removing RC[number] 2
To check two sheets in a single file in Vlookup() 1
Copying Formulas 2
IF OR Formula 1
Logical Functions 5
Formula to return text 1
An easier way? 9

Back
Top