+ Reply to Thread
Results 1 to 4 of 4

If Function needed some correction in what I am doing wrong

  1. #1
    Forum Contributor
    Join Date
    07-30-2013
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    112

    If Function needed some correction in what I am doing wrong

    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.
    Last edited by chandannasta; 09-05-2014 at 03:37 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: If Function needed some correction in what I am doing wrong

    in excel 2003 it is allowed to nest 7 if functions.

    I belive it is 64 if functions in excel 2007.

    you have more, so it won't accept the formula.

    Use a table for your data and use VLookup to find the input in cell c2.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    07-30-2013
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    112

    Re: If Function needed some correction in what I am doing wrong

    Is there an easy way instead of entering such a big formula, something a one liner kinda thing

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: If Function needed some correction in what I am doing wrong

    Instead of asking another (new) question, just read my comment in #2.

    If that is not clear, you can start asking about that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Roundup correction needed
    By mikerules in forum Excel General
    Replies: 3
    Last Post: 03-27-2014, 10:12 PM
  2. [SOLVED] Macro Correction Needed to Remove Text and blanks
    By Sweepin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2013, 01:30 AM
  3. [SOLVED] Nested For Loop - Correction Needed
    By joogibabu in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-25-2013, 11:14 PM
  4. Correction needed for Substitute/rept formula
    By mobycane in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2011, 02:59 AM
  5. Correction in Macro needed
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2009, 07:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1