Text is displaying in Userform but not in sheet cell

[ajmalm]

hi, i'm fairly new to excel and am making a userform spreadsheet system.
Basically, i was working out percentages for the system and realised that the formula that has been entered does display the percentage in the userform but not the exact sheet cell. This is a problem as the sheet cell is linked to another cell which if left empty cant work out the final sum. Please help ASAP!

Note: (This is what has been entered within the spreadsheet)
=IFERROR(IF(W2="","",IF(W2="1 Year",Q2*0.05,IF(W2="3 Years",Q2*0.1,IF(W2="5 Years",Q2*0.15,"Error")))),"")

 

[Norie]

Where do you have that formula and how is it linked to the userform?

 

[Andrew Poulsom]

Welcome to MrExcel.

Are you saying that your formula doesn't work? What's in W2 and Q2 when it fails to return the answer you expect?

 

[ajmalm]

Where do you have that formula and how is it linked to the userform?

Basically that formula is supposed to work out the percentage and then display it on that specific sheet cell, however it doesn't, but somehow the percentage is displayed within the userform. I want the formula to which it will display the percentage in the specific sheet cell so i can link it to the userform. Very confusing. Sorry about this.

 

[ajmalm]

In W2 is the number of years. So for example i want the system to display in X2 the discount percentage. So for example, if in W2 there is "1 year" then i want it to display a 5% discount percentage, if there is "3 Years" then i want in X2 10% to be displayed and if there is "5 Years" in W2, then i want 15% in X2. Also in, Q2 is the Total cost, the formula is (=SUM(L3,N3,O3,W3).

 

[Andrew Poulsom]

Your formula works for me:

Excel 2010
	Q	R	S	T	U	V	W	X
2	100						1 Year	5
3	200						3 Years	20
4	300						5 Years	45
5	400						10 years	Error
Sheet1

Cell Formulas
Range	Formula
X2	=IFERROR(IF(W2="","",IF(W2="1 Year",Q2*0.05,IF(W2="3 Years",Q2*0.1,IF(W2="5 Years",Q2*0.15,"Error")))),"")