Posted to microsoft.public.excel.misc

mldancing

external usenet poster

Posts: 28

If - easy question

I thought it was easy but it couldn't work:

I want it to show whatever in A1 if A1 doesn't have a word "cancel" in it:

if(A1="*cancel*",0,A1)

But it didn't work! :-(

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
Easy question for you all	holyearth	Excel Worksheet Functions	3	May 1st 06 08:00 PM
EASY question 2!!	Laura \( '_' \)	New Users to Excel	3	November 25th 05 02:01 PM
new user with easy question? not easy for me	speakeztruth	New Users to Excel	5	June 3rd 05 09:40 PM
easy question	Dahlman	Excel Worksheet Functions	3	April 1st 05 11:11 PM
easy question .... i think	Dean	Excel Discussion (Misc queries)	1	January 6th 05 06:31 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us