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

[Postlki1]

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]

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.

[Postlki1]

OMG...
well, guess that happens when you stare at formulas for too long - canīt see the obvious any more...

Thanks a lot!

Cheers,
Kim