Posted to microsoft.public.excel.worksheet.functions

Duke Carey

Posts: n/a

A little help with a conditional formula, please.

=if(or(a1="Altstatten",b1="Altstatten"),"Yes","No" )

"Altstatten" wrote:

I understand the syntax for an IF formula. (IF(True, Then This, Otherwise
This)

Question is, can I make the first of the three variables an AND or an OR
statement? Have tried a few variations and can't get anything to work.

I'm after...IF(this OR this, then this, otherwiese, this)

Any help??

Thanks
Phillip

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No.	ramana	Excel Worksheet Functions	5	October 21st 05 07:39 AM
Conditional formatting...cont. from 9/25	Guenzak	Excel Discussion (Misc queries)	4	September 26th 05 10:55 PM
conditional formula	Kari	Excel Worksheet Functions	1	September 22nd 05 04:50 PM
Conditional Formatting formula not acceptable?	Thief_	Excel Discussion (Misc queries)	4	July 19th 05 11:54 AM
Formula Dependant Conditional Formatting	LDanix	Excel Discussion (Misc queries)	1	January 13th 05 06:50 PM

All times are GMT +1. The time now is 10:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us