Nested IF Function

  • Thread starter Thread starter Dave J
  • Start date Start date
D

Dave J

Can someboby please help,I would like to create a nested
function with a maximum of 12 "IF" statements, have tried
but only able to reach 8 before error occurs.Example of
the 12 nested "IF" functions = IF(a3=5,58.8,IF(a3=6,71,IF
(a3=7.23,89.2,IF(a3=8,99.5,IF(a3=9.09,113,IF
(a3=10,125.5,IF(a3=10.87,137.5,IF(a3=13.06,168,IF
(a3=15,195.4,IF(a3=15.41,199,IF(a3=17.48,229,IF
(a3=20.41,271)))))))))))) Any help would be much
appreciated.
 
Hi
not possible as there's a maximum of 7 nested functions. In your case
use a lookup table. e.g. on a separate sheet called 'lookup'
A B
5 58.8
6 71
7.23 89.2
....

now use the following formula
=VLOOKUP(A3,'lookup'!$A$1:$B$20,2,0)
 
Back
Top