Formula not Working

[aparvez007]

Hi All,


below formula not working Selcell (Name Range(B1))is link to radio button.


=IF(SelCell="1",D5,IF(SelCell="2",P5,IF(SelCell="3",AB5,IF(SelCell="4",AN5,""))))


Please help...

 

[anupamtiwari05]

Hi aparvez007,


Remove double quotes from the numbers e.g "1" should be like 1, then your above formula will work correctly.


Let me know if still you face problem.


Thanks & Regards,

Anupam Tiwari

 

[aparvez007]

Oppp big mistake...


Thanks Anupam working fine... sorry to trouble you...

 

[anupamtiwari05]

Welcome aparvez007


Regards,

Anupam