| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF formula
I would like to write an IF formula that states the following
IF((A2=A1) and (B2=B1), TRUE, FALSE) it doesn't seem to work |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel IF formula
=IF(AND(A2=A1,B2=B1),TRUE,FALSE)
"JMM" wrote in message ... I would like to write an IF formula that states the following IF((A2=A1) and (B2=B1), TRUE, FALSE) it doesn't seem to work |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel IF formula
Perfect!!!!! tyvm
"PCLIVE" wrote: =IF(AND(A2=A1,B2=B1),TRUE,FALSE) "JMM" wrote in message ... I would like to write an IF formula that states the following IF((A2=A1) and (B2=B1), TRUE, FALSE) it doesn't seem to work |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel IF formula
=IF(AND(A2=A1,B2=B1),TRUE,FALSE)
I think the IF part of the formula can be eliminated completely... =AND(A2=A1,B2=B1) Rick |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel IF formula
You are correct. But if the OP decides to do something other than "TRUE"
"FALSE", then they will need to apply the IF statement. Thanks for the simplification. Regards, Paul "Rick Rothstein (MVP - VB)" wrote in message ... =IF(AND(A2=A1,B2=B1),TRUE,FALSE) I think the IF part of the formula can be eliminated completely... =AND(A2=A1,B2=B1) Rick |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel IF formula
Rick,
This one didn't seem to work but leaving teh IF in worked fine. ty "Rick Rothstein (MVP - VB)" wrote: =IF(AND(A2=A1,B2=B1),TRUE,FALSE) I think the IF part of the formula can be eliminated completely... =AND(A2=A1,B2=B1) Rick |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel IF formula
Now you've got us worried.
As a matter of interest, what values do you have in A1, A2, B1, and B2, that cause =IF(AND(A2=A1,B2=B1),TRUE,FALSE) to give a different answer from what you get with =AND(A2=A1,B2=B1) ? Are you 100% sure that you've got the formulae right? Did you copy them from the newsgroup into your spreadsheet, or did you retype them? When you say that =AND(A2=A1,B2=B1) didn't seem to work, what answer did you get for which inputs? -- David Biddulph "JMM" wrote in message ... Rick, This one didn't seem to work but leaving teh IF in worked fine. ty "Rick Rothstein (MVP - VB)" wrote: =IF(AND(A2=A1,B2=B1),TRUE,FALSE) I think the IF part of the formula can be eliminated completely... =AND(A2=A1,B2=B1) Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Linear Mode
