Results 1 to 11 of 11

Many Condition with IF Function

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2010
    Location
    India
    MS-Off Ver
    2007
    Posts
    17

    Question Many Condition with IF Function

    Hi All

    I want to create a formula which calculates the cell value based on another cells value.

    For Eg :-

    =IF(F2<=5000, (5000*0.01%), "", IF(F2>5000 BUT <=10000, (10000*.01%), "" ))
    I want to calculate the value based on the F2 Cell. So, suppose if F2 Cell is less than 5000, then the answer should be 5000*0.01%.
    If it is greater than 5000 but less than 10000, then 10000*0.01%.

    The same thing goes on with multiples of 5000. [IF greater than 10000 but less than 15000, then 15000*0.01%, IF greater than 15000 but less than 20000, then 20000*0.01% .........]

    If the figure in the cell F2 comes out as 50,000 or 1,00,000 then i will have to write many IF conditions
    Is there any way by which i can calculate without writing so many IF's ?
    Last edited by Aumkar; 07-30-2010 at 08:09 AM. Reason: Problem Solved

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