L
LRogers81
Here's the situation, I have a problem that has 20 units purchased and
I receive a 7% discount for over 20 units purchased. Cost per unit is
$52. Therefore, in the following If statement, the total would be 20
* $52 * .07 = 72.8 then take this total and subtract if from 20 * $52
which should equal $967.2 but I get a negative with my statement. I
think it's easy but I don't see it, please advise...thanks...
Dim foundRowNum As Integer
Dim numberPurchasedStr As String
Dim totalSpent As Currency
Dim unitCostRow As Currency
Dim discountRow As Double
If (CInt(numberPurchasedStr) >= Range("C" & foundRowNum).Value) Then
totalSpent = CDbl(numberPurchasedStr) * unitCostRow *
discountRow _
- CDbl(numberPurchasedStr) * unitCostRow
I receive a 7% discount for over 20 units purchased. Cost per unit is
$52. Therefore, in the following If statement, the total would be 20
* $52 * .07 = 72.8 then take this total and subtract if from 20 * $52
which should equal $967.2 but I get a negative with my statement. I
think it's easy but I don't see it, please advise...thanks...
Dim foundRowNum As Integer
Dim numberPurchasedStr As String
Dim totalSpent As Currency
Dim unitCostRow As Currency
Dim discountRow As Double
If (CInt(numberPurchasedStr) >= Range("C" & foundRowNum).Value) Then
totalSpent = CDbl(numberPurchasedStr) * unitCostRow *
discountRow _
- CDbl(numberPurchasedStr) * unitCostRow