Needing to know how to use a "and" in a formula....

Posts: n/a

hi,
try this format
=if(and(a1="",a2=""),"not enough data",A1+A2)

-----Original Message-----
I'm trying to use an and statment in an if formula to
only run a
formula if both cells have data in them. For simplicity
lets use:

if(a1="" and a2="","Not enough data",a1+a2)

Any ideas?
.

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
revert formula insertion to old method	Don't be a pain in the ass	Setting up and Configuration of Excel	0	January 24th 05 01:49 PM
Simple formula doesn't quite add up	circeo	Excel Discussion (Misc queries)	3	January 17th 05 09:04 PM
how do I make a formula NOT change when the data range is moved?	Alida Andrews	Excel Discussion (Misc queries)	2	January 6th 05 09:02 PM
Converting an Excel formula to an Access query formula	Adam	Excel Discussion (Misc queries)	1	December 15th 04 03:38 AM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula?	Arvi Laanemets	Excel Discussion (Misc queries)	0	December 2nd 04 11:29 AM

All times are GMT +1. The time now is 05:42 PM.

Menu

About Us