Jocko_MacDuff116

Posts: n/a

HD I build funct @if cell=AorBorC then ...else if cell=DorE then

Does anyone know how to build a formula as follows

if(a4='apple' or 'pear' or 'plum', then 'fruit' else
if(a4='carrot' or 'bean', then 'veg' else
if(a4='bun' or 'cake' or 'donut' then 'pastry' else a4)))

I have been unable to find satisfactory info re or & and as part of
functions.

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
Build in Code	B.G.	Excel Worksheet Functions	1	April 20th 05 09:30 PM
How can I build a pivot table from multiple worksheets which are .	Richard Stephens	Excel Discussion (Misc queries)	2	February 26th 05 10:04 PM
How would I build an "if" formula...	CMS1W8	Excel Worksheet Functions	1	January 28th 05 03:21 PM
How do I build a database of names and addresses?	Masterguide	Excel Discussion (Misc queries)	2	December 29th 04 09:26 PM
How to Build an Excel-Report ?	Martin Meier	Excel Discussion (Misc queries)	1	December 22nd 04 01:49 PM

All times are GMT +1. The time now is 06:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us