Formula to add increments of 5 and 1 in the same cell

[fredtriest]

I was hoping to get assistance with a formula that will look at a numeric value in one cell, and then apply a formula that will take that number and apply itself to another cell with custom text and make increments of +1 on an entirely different number (starting at 1).

For example:

5	$5 can buy 1 widget to take home <tbody> </tbody>
5	$5 can buy 1 widget to take home <tbody> </tbody>
5	$5 can buy 1 widget to take home <tbody> </tbody>
10	$10 can buy 2 widgets to take home <tbody> </tbody>
10	$10 can buy 2 widgets to take home <tbody> </tbody>
15	$15 can buy 3 widgets to take home <tbody> </tbody>
15	$15 can buy 3 widgets to take home <tbody> </tbody>
15	$15 can buy 3 widgets to take home <tbody> </tbody>
20
20
25
30

<tbody>
</tbody>

Any help is greatly appreciated!

 

[Scott Huish]

Your pattern would seem to indicate dividing by 5. If this is the case this would be simpler.

If that's the case, then this formula would work:
=DOLLAR(A1,0)&" can buy "&TEXT(A1/5,"[=1]0 ""widget"";0 ""widgets""") & " to take home"

Copy down.

 

[BrianJN1]

I haven't worried about the actual value to be held in A1 except that it must be a multiple of 5.
Formula in B1:
=IF(A1=5,CONCATENATE("$",A1," can buy ",A1/5," widget to take home"),CONCATENATE("$",A1," can buy ",A1/5," widgets to take home"))

 

[fredtriest]

Both worked beautifully. Thank you!!!

 

[BrianJN1]

Scott's version is tidier (I'm just working out the equivalent of my IF in his formula). Anyway, if your are not used to the IF function then keep that in mind for other purposes, it is quite useful.