Validation Text & Multiplication

[harrybillyard9]

Hi,

I have come across a small issue where i want to add text to the end of the cell that shows the number 2 in the picture attached

i want it to shows Year if the number is 1 but i want it to show years if the number in the cell is greater than 1. IE so it is plural.

Any help much appreciated

 

[Joe4]

What is your exact formula in that cell returning the number 2?
And if any of the other cells have formula using that number, please post those formulas too.

 

[harrybillyard9]

Column C is a date entered by the user, the frequency is just a validation of 1,2,3 which i want to say year or years after, Column E has the following formula =IFERROR(DATE(YEAR(C4)+CHOOSE(D4,"1","2","3"), MONTH(C4), DAY(C4))," ")

 

[Joe4]

So, why not just change the validation in column D from: "1,2,3" to "1 Year, 2 Years, 3 Years"?

 

[harrybillyard9]

If the validation has text in the formula shows an error, my iferror currently stops showing the error

Thanks for your assistance

 

[Joe4]

Change your formula in cell E4 to this:

=IFERROR(DATE(YEAR(C4)+LEFT(D4,1),MONTH(C4),DAY(C4)),"")