joe

Posts: n/a

Thanks guys

"Dave Peterson" wrote:

=if(and(a1="",b1="",c1=""),"hai",if(and(d1="",e1=" "),"hello","what goes here?"))

joe wrote:

I need to create a formula which states like this

IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then
'Hello')

Can you guys help

--

Dave Peterson

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
Nested if question	dakotasteve	Excel Discussion (Misc queries)	3	September 15th 05 09:47 PM
How do I find and replace a question mark in Excel?	Ranpalandil	Excel Discussion (Misc queries)	1	September 7th 05 10:20 PM
Why are my nested sub-totals are displaying incorrectly?	chiefdean13	Excel Discussion (Misc queries)	1	July 20th 05 05:45 AM
IF NESTED Question	Heather	Excel Worksheet Functions	4	April 27th 05 12:08 PM
An easy macro question and one I believe to be a little more diffi	TroutKing	Excel Worksheet Functions	3	January 18th 05 09:17 PM

All times are GMT +1. The time now is 03:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us