IF THEN statement - Formula

[Guest]

I need a formula that will pull an amount if the amount goes over below a
certain amount:
Example
Cell G17 41.09%
Cell I17 41.01%
Cell J17 55.48

My formula needs to be as follows: If cell G17 goes below cell I17 then G17
needs to pull the amount in I17, If cell G17 goes above cell J17 it needs to
pull the amount in J17, if the amount does not go above or below then the
amount in G17 needs to saty.
Any assitance is greatly appreciated.

 

[Guest]

G17 cannot contain both a value AND a formula ... so you will need to
re-think your requirement.

 

[Guest]

OK lets make cell H17 Blank...

Example

 

[Guest]

You'll need to put your formula somewhere other than G17 (or you'll lose the
value in G17). Let's say it goes in K17.

So, in K17 put "if(G17<I17,I17, if(G17>J17,J17,G17))

Will