IF formula

[Mandy]

I am trying to create a IF formula to return certain information:

If B2=COMERCIAL FINANCE

I want it to return certain numbers like

if b2=comercial finance then return 24567
if comercial finance is not selected I want it to be blank

There will be a list to choose from like
COMERCIAL FINANCE=2345
CONSUMER & INDUSTRIAL=3455
CONSUMER HOME SERVICES=4579

And so forth

 

[Mike Mueller]

SELECT CASE B2
CASE "Commercial Finance"
rValue = 2345
CASE "Consumer & Industrial"
rValue = 3455
CASE "Consumer Home Services"
rValue = 4579
CASE ELSE
rValue = ""
END SELECT