Results 1 to 16 of 16

Unknown error, possible formula too long.

Threaded View

  1. #1
    Registered User
    Join Date
    12-09-2011
    Location
    Latvia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Thumbs up Unknown error, possible formula too long.

    Hello everyone. I have this problem with EXCEL 2003: i enter this formula =if(D2>=275;10;if(D2>=265;9;if(D2>=255;8;if(D2>=250;7;if(D2>=245;6;if(D2>=235;5;if(D2>=230;4;if(D2>=220;3;if(D2>=215;2;if(D2>=200;1;0)))))))))) and it gives me an error. When i shorten this formula it works perfect. I know that excel allows 1024 characters long formulas, my formula is not that long, how do you think where could be a problem in this formula? I tried other formulas about same size and same error shows up.
    Last edited by Saidrex; 12-10-2011 at 11:25 AM.

Thread Information

Users Browsing this Thread

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

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