Posted to microsoft.public.excel.misc

Ricter

Posts: n/a

Use IF to change value in a different cell when TRUE (or FALSE)?

I'd like to do the following:

=IF(A1=10, B1="Right", "Left")

If not IF, then how?

Thanks.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shorten a Macro	mully	Excel Discussion (Misc queries)	7	December 30th 05 05:52 PM
I Need a formula to evaluate a cell with + or - values	Bob in Oklahoma	Excel Worksheet Functions	6	October 31st 05 02:41 PM
Cell Change Color - Need Help	alani	New Users to Excel	3	June 29th 05 03:50 PM
SQL - Auto Refresh Upon Cell Value Change	Elliot J	Excel Worksheet Functions	1	May 12th 05 10:22 AM
How can I get a cell locked if the condition is false?	FareedAhmed76	Excel Worksheet Functions	1	February 18th 05 01:49 PM

All times are GMT +1. The time now is 08:32 AM.

About Us

"It's about Microsoft Excel"