Posted to microsoft.public.excel.worksheet.functions

deen

external usenet poster

Posts: 45

If Condition Problem

Hi,

=IF(AND(B460<21),"NOT",IF(B421<60,"ELI"))

this formula not working,

i want result in A2 Not or ELI,

If thr is any possible do in macro pls let me abt the, bcoz new to the
macro.

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
lookup with multiple condition, but one condition to satisfy is en	Eddy Stan	Excel Worksheet Functions	2	October 27th 07 02:06 PM
Vlookup using if condition or any other way to slove problem	dhir	Excel Worksheet Functions	3	June 16th 07 07:19 AM
Combine an OR condition with an AND condition	Will	Excel Discussion (Misc queries)	1	April 6th 07 03:52 PM
countif condition problem	Scott	Excel Worksheet Functions	8	November 11th 05 08:59 AM
Problem with IF condition or vector lookup?	J-Philippe	Excel Worksheet Functions	4	January 15th 05 08:41 PM

All times are GMT +1. The time now is 07:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us