Value if between two criteria

[Jennyb7714]

I need to be able to assign a sale within a "bucket". Saying if 4500 falls within 5,000 and 50,000, then the result would be 4500 if it doesn't the result would be zero.
Can anyone help?
Appreciate it

 

[HalfAce]

I'm afraid I don't understand.
How / (when?) would 4500 fall within 5000 & 50000?

 

[Jennyb7714]

sorry, I believe I have it.....if(and(G12>Q3,G12<Q2),G12,0) basically saying if it's greater than 5000 and less than 50000, then the value of the sale is returned (45000) if it's not between those two value's then it's zero...

Thanks so much for responding

 

[ActuaryGuy123]

Do you want it in excel or vba?

Excel:

=IF(AND(SellAmount >=5000, SellAmount < 50000), SellAmount, 0)

VBA:

Public Sub Testing123()
Dim SellAmount#, DesiredOutput# '# is for double data types

SellAmount = 700

If SellAmount >= 500 And SellAmount < 50000 Then
DesiredOutput = SellAmount
Else
DesiredOutput = 0
End If

MsgBox DesiredOutput
End Sub

You could do a user-defined function too if you really wanted to get fancy.