Add between 10% to 20% random to numbers in cloumn F

[parscon]

Hi everyone
I have a List that i need add Random between 10 to 20 Percent to the value are in Column F . and must ignore blank cell and cell has character only apply in cell with number .

For Example If i have 13.5 in Column F , add 11 Percent (Between 10 to 20 Percent) will be 14.985 . Could you please help me on this .

Appreciate for all you help and effort.

[snb]

Is that the current inflation percentage each day?

[parscon]

No , It is not just it will be run for one time and important to be random mean from 10 to 20 Percent .. .between these .. my list is about 94000 row .

[Paul_Hossler]

Fixed value and formula




Option Explicit


Sub FixedValue()
Dim r As Range, c As Range


Set r = ActiveSheet.Columns(6).SpecialCells(xlCellTypeConstants, xlNumbers)


Randomize


For Each c In r.Cells

'fixed value
'c.Offset(0, 1).Value = c.Value * (1.1 + 0.1 * Rnd)

'formula
c.Offset(0, 1).Formula = "=" & c.Address & "*(1.1+0.1*RAND())"

Next


End Sub

[SamT]

The result will be between 10.00000000000% and 20.99999999999% increase
Option Explicit

Sub AddToF()
Dim FArr
Dim i As Long

FArr = Intersect(Range("F1").CurrentRegion, Range("F:F")).Value

For i = 1 To UBound(FArr)
If IsNumeric(FArr(i, 1)) Then _
FArr(i, 1) = FArr(i, 1) * 1 + (Int((20 - 10 + 1) * Rnd + 10) / 100)
Next i

Range("F1").Resize(UBound(FArr, 1)) = FArr
End Sub

Example Returns, as percent additions:






10.999999940395400%


14.000000059604600%


18.000000715255700%


14.000000059604600%


15.999999642372100%


18.000000715255700%


17.000000178813900%


11.999999731779100%


15.000000596046400%


18.999999761581400%


11.999999731779100%


15.999999642372100%


15.000000596046400%


12.999999523162800%


20.000000298023200%


10.999999940395400%


17.000000178813900%


15.999999642372100%


17.000000178813900%


14.000000059604600%


12.999999523162800%


14.000000059604600%


10.000000149011600%

[arnelgp]

copy and paste to New Module:



Public Function fn1020pct(r As Range) As Variant
Dim num As Double
fn1020pct = ""
If IsNumeric(r & "") Then
num = CDec(RandBetween(10, 20)) / CDec(100)
fn1020pct = r.Value * (1 + num)
End If
End Function




Public Function RandBetween(Optional Lowest As Long = 1, Optional Highest As Long = 9999)
' Generates a random whole number within a given range
Randomize (Timer)
RandBetween = Int(Rnd * (Highest + 1 - Lowest)) + Lowest
End Function




on the cell you want to apply the 10~20%, add this formula:

=fn1020pct(F1)


copy the formula down.

[parscon]

Well Done and Thanks for your works and effort .