N E Body

Posts: n/a

If formula evaluating 2 cells contents

Hi

I cannot get my head round this one at all

I want to enter a formula into a cell <eg C1 to return a value of
"Complete" if A1 is a number and B1 is not blank.
If A1 is a number and B1 is blank C1 value is "Outstanding"
if A1 is blank then C1 is " " <empty

Any Ideas?

Regards
Kenny
Win NT and 2000 with Office 97

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
exchange contents of cells	\jeremy via OfficeKB.com\	New Users to Excel	6	July 8th 05 03:14 AM
Again-revealing the contents of formula	srinivasan	Excel Worksheet Functions	0	July 5th 05 06:25 AM
Macro to remove contents of cell and move all other contents up one row	adw223	Excel Discussion (Misc queries)	1	July 1st 05 03:57 PM
How to insert the contents of two cells in a footer?	Pank	Excel Discussion (Misc queries)	4	June 2nd 05 02:32 PM
Applying formula to only NON-EMPTY cells in range	Tasi	Excel Discussion (Misc queries)	5	March 29th 05 10:48 PM

All times are GMT +1. The time now is 10:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us