Thread: 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)

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)

Did that help 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)

Did that help you?

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

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

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?

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)

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.

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