Posted to microsoft.public.excel.misc

ChuckW

Posts: n/a

IF then statement question

Hi,

I have four cells of data (A1 through D1). I have created an If then
statement where If A1 is less than 500, D1 = B1. I also want to have it so
that If A1 500 then D1=C1. How would I write a formula for this. Can
anyone help?

Thanks

--
Chuck W

Reply With Quote

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
IF Statement Question 0 values & blank cells	joshmd9909	Excel Worksheet Functions	6	October 10th 05 01:14 PM
If Statement Question	redwings04	Excel Worksheet Functions	4	July 4th 05 09:42 PM
IF Statement Question	Scott	Excel Worksheet Functions	15	June 14th 05 07:56 PM
IF Statement question	Patrick Simonds	Excel Worksheet Functions	7	May 8th 05 04:03 PM
IF Statement question	gryfon	Excel Worksheet Functions	6	May 4th 05 09:21 AM

All times are GMT +1. The time now is 08:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us