Hi, I have 7 check boxes, and only 1 can be true at a time. They are for different property taxes. Im trying to create a property tax calculator for my boss. Im trying to create an if state that will populate the tax rate for the 1 true statement out of the 7 total options. I tried this with a drop down, but couldn't find a way to assign values to the drop down selections either.
Hi Destiny.
I need something to work with.
I have created something using Option buttons for you.
The Four buttons are in a frame so only one can be true at any time.
Each is linked to a different cell so I can use the match function to find out which option was selected.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Last edited by mehmetcik; 01-04-2019 at 05:12 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Could you send your template in excel
You need to use option buttons, not checkboxes.
It should be possible with checkboxes, but it would need vba, you can't do it with formulas, etc.
IDK what most of what you said means. Im just a secretary actually, and was asked to build this calculator. Theres no client information in it though. Its not an excel sheet for a private company or anything though.
Ultimately the goal is that it will show the houses proposed values, the exempts, the taxable value, the tax rate, and the $ amount of taxes.
My boss then comes in and does an agreed value with you, which can change the exempts $ amount, and it will change the tax value, which lowers the persons taxes.
I have the calculator for the exempts figured out, except for some reason it wont SUM so that it can auto populate onto sheet 1.
There will only ever be 1 city tax rate, or none. 1 county tax rate, 1 ISD tax rate, and the possible water tax rate. So for city tax rates there are 7 total choices, with the possibility of all being false or 1 being true.
My boss wants to be able to just pick the tax rate by its name, and its value to appear in the calculator.
I think my project is attached.
If you want to use Data Validation then
paste this formula into cell E4 of Sheet 1 and fill down. =INDEX(Sheet3!$B$2:$B$15,MATCH(D4,Sheet3!$A$2:$A$15,0),1)
Last edited by mehmetcik; 01-04-2019 at 05:58 PM.
I tried that, only I put the code in H4 on Sheet 1. It works if the drop down matches the check box. But only in H4. It didnt work in H5-H7.
Currently I have E4 as the proposed value of the house, and I need that information.
Im not allowed to change the layout of the calculator because my box wants for sheet 1 to be something he can print out to show his clients.
did you leave out the dollar signs?
=INDEX(Sheet3!$B$2:$B$15,MATCH(D4,Sheet3!$A$2:$A$15,0),1)
Last edited by mehmetcik; 01-04-2019 at 05:58 PM.
I've taken the liberty of adding in a vba solution to your file that will turn off all other checkboxes of the same type if you try to turn more than 1 on.
This isn't going to mean a lot to you, (check for some observations after the code though) but for the benifit of forum rules, the following code has been assigned to all of the checkboxes except the last one.
Something that will mean something to you is that I've noticed #VALUE! errors in multiple places, being caused by using the TEXT and DOLLAR functions in various formulas.
Please Login or Register to view this content.
The ones that I found were in D2 and D4 of both Value Exempts sheets. Which I've fixed for you.
The error does not show in the cell with the TEXT formula, but in the one below when the checkbox is on.
The formulas with the DOLLAR function appear OK at a glance, but if you look at your total figure in G4 you will notice that it does not match the actual total. This is because SUM will not include any amounts that are in text format, which includes anything using the DOLLAR function.
I haven't fixed any of the DOLLAR issues, gives you something to do
Last bit I've done is remove the data validation in Sheet1 column D and set formulas in place that will mimic the boxes checked on sheet 3.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks