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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02:21 PM.