nesting fuction to large - options

[lesley burlingham]

I have a script which changes the cell content dependant on an answer. I have 9 option. I am getting an error saying to many for function.

Script
=IF(R7=4,"4 weekly PMI Inspection frequency",IF(R7=5,"5 weekly PMI Inspection frequency", IF(R7=6,"6 weekly PMI Inspection frequency",IF(R7=7,"7 weekly PMI Inspection frequency",IF(R7=8,"8 weekly PMI Inspection frequency",IF(R7=9,"9 weekly PMI Inspection " ,IF(R7=10,"10 weekly PMI Inspection ", IF(R7=11,"11 weekly PMI Inspection ", IF(R7=12,"12 weekly PMI Inspection ","13 weekly PMI Inspection "))

 

[NARAYANK991]

Hi Lesley ,

Why not use something like this ?

=R7 & " weekly PMI Inspection frequency"

Narayan

 

[lesley burlingham]

So simple, thank you very much