if and function

[Patcheen]

im using this formula to give me whats in fixtures and results I4 but it says

You've entered too many arguments for this function


=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6),'Fixtures and Results'!F4,local!A101,'Fixtures and Results'!I4,"")

do i need to add something to it if so what?

Tai

the result should be Faranfore

 

[JoeMo]

The IF arguments should be like: IF(AND(1st condition,2nd condition),Value if True,Value if false)

=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and  Results'!c4=local!b6),'Fixtures and Results'!F4,local!A101,'Fixtures and  Results'!I4,"")

the bit in red is the part Excel sees as too many arguments.

 

[Yongle]

'=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6),'Fixtures and Results'!F4,local!A101) ???? ->,'Fixtures and Results'!I4,"")

If both conditions in red are met then return value in green, otherwise return value in blue
Your formula has an extra 2 values

- what is the condition that should be satisfied ?
- what should be returned if TRUE ?
- what should be returned if FALSE ?

Previous reply says pretty much the same thing. I must learn to type faster!

 

[Patcheen]

i totally understand what ye are saying so is there anyway to include the extra condition?

 

[JoeMo]

What is the extra condition?

 

[Patcheen]

the one that excel has the prob wit as it were or would i need a totally different formula

 

[Patcheen]

If all these are met '=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6),'Fixtures and Results'!F4,local!A101) then it returns the answer from I4 i know it only does the red highlighted once so is there a formula that could do this?

=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6),AND('Fixtures and Results'!F4,local!A101),'Fixtures and Results'!I4,"")) i included another AND but it gave me #Value!

 

[JoeMo]

Did you mean:

=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6,'Fixtures and Results'!F4=local!A101),'Fixtures and  Results'!I4,"")

 

[Patcheen]

hope somehow this sample workbook helps this is dropbox link https://www.dropbox.com/s/096c10kqlhkjq06/Sample.xlsx?dl=0

 

[Patcheen]

Any Suggestions?