Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 12

Need help with IF command

Hi!

I would like to do something like:

IF(B3=8 and C3=8;1;0)

if (B3 is equal or bigger than 8 and c3 is equal and bigger than 8) this is
true give me 1 otherwise 0. How do I write that?

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
Pivot Table Error Message - "Command Text not set for command obje	Jeff Divian	Excel Discussion (Misc queries)	0	November 7th 07 10:26 PM
If Command	MCrum	Excel Discussion (Misc queries)	5	August 29th 05 05:08 PM
Command	Derrick Robinson	Excel Worksheet Functions	3	May 31st 05 02:19 AM
Map command	suemkay	Excel Discussion (Misc queries)	1	January 19th 05 05:56 PM
Excel has a "Find Next" command but no "Find Previous" command.	Michael Fitzpatrick	Excel Discussion (Misc queries)	2	January 10th 05 11:45 PM

All times are GMT +1. The time now is 01:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us