Problem With Excel Formula

[cadarnofjeal]

I have a work spreadsheet that I use to upload products and on the discounts section I use this formula:

=IF(ISERROR(FIND("Retail",$B2)),SUM(INDEX(Products!$N$2:$N$2000, MATCH($A2, Products!$A$2:$A$2000, 0))*0.5),IF(ISERROR(FIND("Distributor",$B2)),IF(SUM($C2>5),SUM(INDEX(Products!$N$2:$N$2000, MATCH($A2, Products!$A$2:$A$2000, 0))*0.542),SUM(INDEX(Products!$N$2:$N$2000, MATCH($A2, Products!$A$2:$A$2000, 0))*0.65)),"Error"))

The problem is that if the customer is a retailer no matter what the value in C5 it will multiply the price by 54.2%?

I'm not sure why this is and have even tried simplifying the file.

Regards,
Cad

 

[WaterGypsy]

I assume you mean C2 as that is the cell used in the formula..... it might be that the contents of C2 are text rather than numeric