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

05-01-2014, 10:12 AM

doni49

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

Office 2010 64bit

Novice

Join Date: May 2014

Posts: 2

You can't assign a value to a cell from within a different cell's formula. You CAN assign a forumula to H17 that returns the value you're looking for.

Take a look at the attached file.

Attached Files

test.xlsx (12.9 KB, 9 views)

« 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 04:32 PM.