LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default IF THEN statement - Formula

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My IF statement won't work for my formula AdzRay Excel Worksheet Functions 5 February 3rd 07 10:51 PM
IF statement formula JaB Excel Worksheet Functions 4 September 15th 06 04:12 PM
Can I use IF statement with a formula? Michael NYC Excel Worksheet Functions 1 October 1st 05 04:45 AM
if statement formula Marlis Excel Discussion (Misc queries) 2 August 17th 05 04:57 AM
If statement formula lintan Excel Worksheet Functions 6 November 22nd 04 10:29 PM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"