Thread: How to get the if then else statement to work
View Single Post
 
Old 04-29-2014, 01:16 PM
pamed53 pamed53 is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Apr 2014
Location: Gainesville GA
Posts: 1
pamed53 is on a distinguished road
Smile How to get the if then else statement to work
If (A17 = "512/46000/3B") Then
H17 = "3665.00"

Else

If (A17 = "302/46000/3B") Then
H17 = "4600.00"

I am trying to set up a spreadsheet to select the contract in Column A and it automatically fill in the price in column H. I have got this code set up in VBA but I can not figure out to get it to run in Excel automatically.

Help!
Reply With Quote