IF function

**gthemerc** · 07-26-2010, 05:26 PM

I'm looking to have multiple conditions on a single IF function if that is possible.

I'll do my best to explain what it is I'm trying to accomplish.

=IF(A10 is greater than 5 and less than or equal to 10 and Cells A11,A12, and A13 are greater than one, then "XXXXXXX"

As always thanks again in advance for all the help!

**contaminated** · 07-26-2010, 05:28 PM

Try

=IF(AND(A10>5,A10<=10,A11>1,A12>1,A13>1),"ValueIfTrue","ValueIfFalse")

**DonkeyOte** · 07-27-2010, 03:19 AM

Another alternative

=REPT("XXXXXXX",AND(CEILING(A10,5)=10,MIN(A11:A13)>1))

if only to demo some other functions which might be of interest

IF function

LinkBack

Thread Tools

Rate This Thread

Display

IF function

Re: Need some help with an IF function

Re: IF function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions