Nasty nested IF function will only return "value if false"

**Postlki1** · 04-20-2013, 05:06 AM

Hello everybody!

Once again I am spending a Saturday on my Excel Form that still needs improvements...

Just now I am trying to tell a cell that it should translate VAT rates into a certain code. But somehow it won´t work. It might be the way I have to write the percentage - 8% vs. 0,08 vs. just 8?! I have tried various ways, but it just won´t come around. It will always display I0.

=IF('CH ASSA'!J7=3,"I3",IF('CH ASSA'!J6=2.5,"I25",IF('CH ASSA'!J8="8%","I8","I0")))

This are the steps:
IF 3% in cell J7 then rename to I3
IF 2.5% in cell J7 then rename to I25
IF 8% in cell J7 then rename to I8
none if the conditions met? then return I0

Cell J7 is formated to present its value in percentage. So you will see 8% aso. The value is a return of a a nested IF and VLOOKUP using a name range.

OK, all ideas are highly appreciated!

Thanks,
Kim

**Andy Pope** · 04-20-2013, 05:15 AM

Try this,
=IF('CH ASSA'!J7=3%,"I3",IF('CH ASSA'!J7=2.5%,"I25",IF('CH ASSA'!J7=8%,"I8","I0")))

Your post says the cell to check is J7, for all 3 values but your formula is testing cells J7,J6 and J8.