IF Command

Feb 24th, 2002, 08:16 PM

I am need of the "IF", however, instead of comparing "True" and "False", I need it to compare to cells and see if thier value is the same. Is this possible?

Thanks,
Eric

Anne Troy · Feb 24th, 2002, 08:20 PM

Sure, but what do you want it to return? If they're both the same, then it's true, if not, then it's false.

But you could have it say Yes or No instead.

Like this:

=if(a1=b1,"Yes","No")

or

=if(a1<>b1,a1,b1*2) a sample if statement.

Feb 24th, 2002, 08:24 PM

What I have is this. If Cell A and B are the same value, then cell C (with the formula in it) would be value X, if cell A and B are different values, then cell C would be X+10)

The Values of cell's A and B are derived from VLOOKUP statements.

Anne Troy · Feb 24th, 2002, 08:27 PM

=if(a1=b1,X,X*10)

anno · Feb 24th, 2002, 08:33 PM

or =IF(EXACT(A1,B1),X,(X+10))

Feb 25th, 2002, 04:37 AM

What's the difference between A1=B1 and Exact(A1,B1)?

Mudface · Feb 25th, 2002, 04:51 AM

EXACT is case-sensitive. If you have 'text' and 'Text' in cells A1 and B1 and in C1 you enter the formula (A1=B1), C1 will show True, if you enter EXACT(A1,B1), C1 will show False. It isn't needed in your case, if you're dealing with numbers, but it's a good tip for future use.

Feb 24th, 2002, 08:27 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	=if(a1=b1,X,X*10) __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 24th, 2002, 08:16 PM	#1
Guest Posts: n/a	I am need of the "IF", however, instead of comparing "True" and "False", I need it to compare to cells and see if thier value is the same. Is this possible? Thanks, Eric

Feb 24th, 2002, 08:20 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Sure, but what do you want it to return? If they're both the same, then it's true, if not, then it's false. But you could have it say Yes or No instead. Like this: =if(a1=b1,"Yes","No") or =if(a1<>b1,a1,b1*2) a sample if statement.

Feb 24th, 2002, 08:24 PM	#3
Guest Posts: n/a	What I have is this. If Cell A and B are the same value, then cell C (with the formula in it) would be value X, if cell A and B are different values, then cell C would be X+10) The Values of cell's A and B are derived from VLOOKUP statements.

Feb 24th, 2002, 08:33 PM	#5
anno Board Regular Join Date: Feb 2002 Posts: 202	or =IF(EXACT(A1,B1),X,(X+10))

Feb 25th, 2002, 04:37 AM	#6
Guest Posts: n/a	What's the difference between A1=B1 and Exact(A1,B1)?

Feb 25th, 2002, 04:51 AM	#7
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	EXACT is case-sensitive. If you have 'text' and 'Text' in cells A1 and B1 and in C1 you enter the formula (A1=B1), C1 will show True, if you enter EXACT(A1,B1), C1 will show False. It isn't needed in your case, if you're dealing with numbers, but it's a good tip for future use.