I do not know what am I doing wrong in this formula, Can anyone correct it please
=IF(C2<2,"300 Rs",IF(C2<3,"400 Rs",IF(C2<4,"500 Rs",IF(C2<5,"600 Rs",IF(C2<6,"700 Rs",IF(C2<7,"800 Rs",IF(C2<8,"900 Rs",IF(C2<9,"1000 Rs",IF(C2<10,"1100 Rs",IF(C2<11,"1200 Rs",IF(C2<12,"1300 Rs",IF(C2<13,"1400 Rs",IF(C2<14,"1500 Rs",IF(C2<15,"1600 Rs",IF(C2<16,"1700 Rs",IF(C2<17,"1800 Rs",IF(C2<18,"1900 Rs",IF(C2<19,"2000 Rs",IF(C2<20,"2100 Rs",IF(C2<21,"2200 Rs",IF(C2<22,"2300 Rs",IF(C2<23,"2400 Rs",IF(C2<24,"2500 Rs",IF(C2<25,"2600 Rs",IF(C2<26,"2700 Rs",IF(C2<27,"2800 Rs",IF(C2<28,"2900 Rs",IF(C2<29,"3000 Rs",IF(C2<30,"3100 Rs",IF(C2<31,"3200 Rs",IF(C2<32,"3300 Rs",IF(C2<33,"3400 Rs",IF(C2<34,"3500 Rs",IF(C2<35,"3600 Rs",IF(C2<36,"3700 Rs",IF(C2<37,"3800 Rs",IF(C2<38,"3900 Rs",IF(C2<39,"4000 Rs",IF(C2<40,"4100 Rs",IF(C2<41,"4200 Rs",IF(C2<42,"4300 Rs",IF(C2<43,"4400 Rs",IF(C2<44,"4500 Rs",IF(C2<45,"4600 Rs",IF(C2<46,"4700 Rs",IF(C2<47,"4800 Rs",IF(C2<48,"4900 Rs",IF(C2<49,"5000 Rs",IF(C2<50,"5100 Rs",IF(C2<51,"5200 Rs",)))))))))))))))))))))))))))))))))))))))))))))))))))
I use excel 2003 & 2007 both.
In Excel 2007, I get this error, it user more levels of nesting then required in the current file format. In Excel 2003 I get this Fomula u typed contains an error.
Bookmarks