If---then make a calculation

I'm trying to make the "if" function do a calculation if the one box is True.


=IF(D7<=11,3.5,IF(D7<=24,2,IF(D7<=49,1.5,IF(D7<=99,1.25,IF(D7<=299,1,IF(D7>=300,0.9))))))

This is the calculation that works...What I need is for a way to tell the cell that is another cell with a checkbox is checked to go ahead and do the calculation. If the check box is not check leave it as "0"

Thanks in advance for the help.

Michael

You get better result on your question if you add a small excel file, without confidential information.

Please also add the expected results manualy in your file.

Try something like:

Formula:

Please Login or Register  to view this content.

Or

Formula:

Please Login or Register  to view this content.

look also for the VLookup formula instead of the multiplied if formula.

Please Login or Register  to view this content.

Always add to whom you are replying.

It's meant as a pseudo reference to whatever cell is linked to your checkbox. You haven't provided any details so it's just a guess to give you an idea what the formula would look like.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Thanks...so if the checkbox is in e7 i would put that in between the quotation marks?

No ...

Formula:

Please Login or Register  to view this content.

Different problem, different question, needs a new thread. You'd need VBA to do what you are asking.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Sounds like the cell is formatted as Text.

Ah, now I've had a chance to look at the workbook on my laptop. You managed to get the double quotes in the wrong place. And, the test needs to be NOT(TRUE) rather than checking for blank.

So, try:

Formula:

Please Login or Register  to view this content.

Copy and paste the formula, don't try to retype it.

Thanks for the rep.