Formula in Data Validation

[Suresh Kusunuri]

Hi All,

I am doing a Tax calculation choosing Tax Rate by using Data Validation. I Required a Formula in Source Box of Data Validation. If not possible, Plz advise other way to get the result.
I attached a Screen Shot for your reference.
Thanks in advance

Suresh

 

[Joe4]

I am not quite clear what the issue is. If you only want to allow them to select 6%, 7.5%, or 10%, then just list those three values in your data validation, i.e.
6%,7.5%,10%

If you don't want to hardcode it, but instead want to pull the values from AA2:AA4, then enter this in the Source box:
=$AA$2:$AA$4

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C
1	6.5
2	7
3	7.5	Yes	6.5
4	10
Main

Cells with Data Validation
Cell	Allow	Criteria
C3:C4	List	=IF($B3="Yes",$A$1:$A$4,"")

 

[Suresh Kusunuri]

I am not quite clear what the issue is. If you only want to allow them to select 6%, 7.5%, or 10%, then just list those three values in your data validation, i.e.
6%,7.5%,10%

If you don't want to hardcode it, but instead want to pull the values from AA2:AA4, then enter this in the Source box:
=$AA$2:$AA$4

Thanks for your respond Mr. Joe. May be I was not explained my problem properly. I can use Name instead of Range or Vlookup from a table in Source Box.


Input value in Z Column is
"Yes" or "No"

Output Value required in AA Column is Based on Z Column
if "Yes" 2%, 3%, 4%, and so on
If "No" The column should be Blank or Zero and locked the Cell.

I used "=IF(Z2="Yes",("2%","3%","4%"),"") and getting invalid.

Now, I Required a formula, which is entered into Source box.

Thanks
Suresh

 

[Joe4]

Now, I Required a formula, which is entered into Source box.

See Fluff's reply above. It looks like that might do what you want.

 

[vmjan02]

I used "=IF(Z2="Yes",("2%","3%","4%"),"") and getting invalid.

Try this
"=IF($Z2="Yes","2%","")
it can display 1 value

 

[Fluff]

@vmjan02
The OP is trying to get a list of values, not just one.
There would be no point in using data validation for one value.

 

[Suresh Kusunuri]

Thank you every one for your respond.

Suresh

 

[Fluff]

Glad we could help & thanks for the feedback.