# excel

• Apr 21st 2008, 07:23 AM
camincho
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)
• Apr 21st 2008, 07:41 AM
colby2152
Quote:

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)

• Apr 21st 2008, 07:51 AM
camincho
Thank you!
Yes, it is Excel, Attachment 5980
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
Quote:

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)

• Apr 21st 2008, 08:54 AM
colby2152
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
• Apr 21st 2008, 09:23 AM
camincho
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
• Apr 21st 2008, 09:24 AM
colby2152
Quote:

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?
• Apr 21st 2008, 09:59 AM
camincho
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)
• Apr 21st 2008, 10:30 AM
colby2152
Quote:

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. (Clapping)
• Apr 23rd 2008, 07:48 AM
camincho
Thank you!
(Star) 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