Entered too many arguments in formulae

[drousyblinx]

Hi,

I'm trying to nest 5 different arguments.

My first formula for two was successful (it returns either Mitre 10, Four Square, or a blank)
=IF(ISERROR(FIND("Four",A3,1)),IF(ISERROR(FIND("Mitre",A3,1)),"","Mitre 10"),"Four Square")

My second formula with three arguments gave the error "you've entered too many arguments for this function" IF(ISERROR(FIND("Four",A3,1)),IF(ISERROR(FIND("Mitre",A3,1)),IF(ISERROR(FIND("Samex",A3,1)),"","Samex","Mitre 10"),"Four Square")

I'm trying to create a Grouping column, so I can combine values from certain customers in a list, as part of a Macro to create a report.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Grouping (formulae here)[/TD]
[TD]Income[/TD]
[/TR]
[TR]
[TD]Four Square 1[/TD]
[TD]Four Square[/TD]
[TD]$5000[/TD]
[/TR]
[TR]
[TD]Four Square 2[/TD]
[TD]Four Square[/TD]
[TD]$4000[/TD]
[/TR]
[TR]
[TD]Four Square Total[/TD]
[TD]Four Square Total[/TD]
[TD]$9000[/TD]
[/TR]
</tbody>[/TABLE]


Any assistance appreciated

 

[tygrrboi]

Does this work?

=IF(ISERROR(FIND("Four",A3)),IF(ISERROR(FIND("Mitre",A3)),IF(ISERROR(FIND("Samex",A3)),"","Samex"),"Mitre 10"),"Four Square")

 

[drousyblinx]

Wow that was simple! Thanks for that!

 

[tygrrboi]

Happy to help.