How to get the if then else statement to work

		Microsoft Office Forums > Microsoft Excel > Excel
How to get the if then else statement to work

FAQ

Thread Tools

Display Modes

04-29-2014, 01:16 PM

pamed53

Windows 7 32bit How to get the if then else statement to work

Office 2010 32bit

Novice

Join Date: Apr 2014

Location: Gainesville GA

Posts: 1

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!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format Switch \* Caps won't work in if..then statement	cwright	Word	2	03-27-2014 04:19 PM
work of labor vs work of excavator	ketanco	Project	1	02-11-2014 08:53 AM
Need help with If, Then Statement Please	cangelis	Excel	4	01-03-2014 09:10 AM
Help with IF Statement	limpbizkit	Excel	4	02-24-2011 09:16 PM
if statement	piper7971	PowerPoint	1	08-19-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:45 PM.