|I'm not sure why, perhaps the way the cell is formatted(?) but it seems that Excel is converting your 1 and 0 to logical 1 and 0, therefore returning TRUE or FALSE.|
That does not happen when I paste your formula into my spreadsheet.
You could try this, but I don't see why you would have to:
This forces a text 1 or 0 in the cell. Depending on what you are doing with the 1 and 0, Excel may or may not consider the text value to be a number. You'll have to try it and see.
If it doesn't like it, you could try this to force a number, but again, you shouldn't have to.
=IF(AND(L6=1, R6=7),1*1,0*1) (untested, since I can reproduce the problem)
I'm just starting to use 2010 on a daily basis, so I don't know if there is a setting that would force 1's and 0's to be considered logical values. I've never heard of it.
Have you tried this formula in a different workbook?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.