if and function

Patcheen

Active Member
Joined
Sep 28, 2015
Messages
388
Office Version
  1. 365
Platform
  1. Windows
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
 
Last edited:

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
The IF arguments should be like: IF(AND(1st condition,2nd condition),Value if True,Value if false)
Rich (BB code):
=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.
 
Upvote 0
'=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!;)
 
Last edited:
Upvote 0
i totally understand what ye are saying so is there anyway to include the extra condition?
 
Upvote 0
the one that excel has the prob wit as it were or would i need a totally different formula
 
Upvote 0
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!
 
Last edited:
Upvote 0
Did you mean:

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

 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top