1. ## excel

PROBLEM 6
Step 2
In Cells D7 - D13, enter a formula using the IF logical function to place the amount in Cells B7 - B13 in cells D7 - D13 if the amount in Cells B7 - B13 is Over $80,000. (If the amount in cells B7 - B13 is greater than$80,000, then the amount should be placed in cells D7 - D13)

2. Originally Posted by camincho
PROBLEM 6
Step 2
In Cells D7 - D13, enter a formula using the IF logical function to place the amount in Cells B7 - B13 in cells D7 - D13 if the amount in Cells B7 - B13 is Over $80,000. (If the amount in cells B7 - B13 is greater than$80,000, then the amount should be placed in cells D7 - D13)
Is this a Microsoft Excel question?

If so, then do the following:

Goto cell D7 and type: =IF(b7>80000,b7,*)

*I don't know what your if false condition is... let's assume you want a minimum of 80,000 placed there, then:

Goto cell D7 and type: =IF(b7>80000,b7,80000)

You could easily do the same with the maximum function

Goto cell D7 and type: =Max(80000,b7)

3. ## Thank you!

Yes, it is Excel, email.xls
I am a newbie, please email me to camincho@gmail.com if you do not get my attachment, so that I can send you exactly what I need, in the meantime, I will try to follow your directions, thank you, Camincho
Originally Posted by colby2152
Is this a Microsoft Excel question?

If so, then do the following:

Goto cell D7 and type: =IF(b7>80000,b7,*)

*I don't know what your if false condition is... let's assume you want a minimum of 80,000 placed there, then:

Goto cell D7 and type: =IF(b7>80000,b7,80000)

You could easily do the same with the maximum function

Goto cell D7 and type: =Max(80000,b7)

4. I am not in a position right now to download attachments, but this link should be a great free (and paid if you choose to buy one of his great books) resource on Excel: Mr. Excel

5. ## Thanks again!, I am getting half way there

Thank you, I have half of my problem solved, and now I just need to find out what to do with the amounts that are less than 80000, right now they are showing with FALSE in the cell, anyway, thanks for your help, sincerely, Camincho

6. Originally Posted by camincho
Thank you, I have half of my problem solved, and now I just need to find out what to do with the amounts that are less than 80000, right now they are showing with FALSE in the cell, anyway, thanks for your help, sincerely, Camincho
That depends on what you are trying to do in your problem? What is the if else condition?

7. ## Here are the details

Quota Over 8000
45000 (leave cell blank if not over 80000)
75000 (leave cell blank if not over 80000)
85000 85000 (fill in amount if over 80000
85000 85000 (fill in amount if over 80000)
55000 (Leave cell blank if not over 80000)
93000 93000 (fill in amount if over 80000)

8. Originally Posted by camincho
Quota Over 8000
45000 (leave cell blank if not over 80000)
75000 (leave cell blank if not over 80000)
85000 85000 (fill in amount if over 80000
85000 85000 (fill in amount if over 80000)
55000 (Leave cell blank if not over 80000)
93000 93000 (fill in amount if over 80000)
Leave blank, so you would simply write O or "" as your FALSE condition.

9. ## Thank you!

Thank you so much for your help! I am so sorry, I am just letting you know how thankful I am for your help, TTUL