check if stock is out approx the 30%

[sal21]

Possible to check if STOCK is approx the +/- 30% of SOLD, in this case i need to rearrange the STOCK.

for example:

i have var STOCK=5000, and SOLD=1985, msgbox("attention!")

Hope understand me...

[HansV]

Code: Select all

    If SOLD > 0.3 * STOCK Then
        MsgBox "Attenzione!"
    End If

[sal21]

Code: Select all

    If SOLD > 0.3 * STOCK Then
        MsgBox "Attenzione!"
    End If

WORK!

now about SOLD and STOCK how to calculate the percentage... based STOCK ?

[HansV]

For example Format(SOLD / STOCK, "0%")