Mazzaropi

Senior Member

Location: Belo Horizonte, Brazil

Posts: 170

Quote:

Originally Posted by R&I Guy

I stumbled across the forum while looking for an answer for this issue.
Thanks in advance, and looks like I will be spending alot of time on this forum!
I want to use the if Then function, for:
I cell A1< A10 and A1< A15 and A1< A20 then, 1 for true and 0 for false.
Seems like it should be possible but can't get it to work.
Thanks

Help from Brazil
Hi R&I Guy

Try to do like this:
=IF(AND(A1<A10,A1<A15,A1<A20),1,0)

Tell me if it´s what you desire.

Have a nice day.

__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil

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
multiple IF Formula help, Please	Karen	Excel Worksheet Functions	4	July 9th 09 05:16 PM
Help with multiple needs formula	markythesk8erboi	Excel Programming	0	April 2nd 08 07:42 PM
formula to add multiple lines with multiple meanings	chubbybat	Excel Discussion (Misc queries)	1	March 3rd 08 10:28 AM
Formula to sum multiple columns on multiple criteria	vito	Excel Discussion (Misc queries)	2	November 15th 07 03:30 PM
HELP!! Multiple Formula	Chantz	Excel Discussion (Misc queries)	7	June 20th 07 05:05 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us