Results 1 to 14 of 14

Need help on IF formula

Threaded View

  1. #1
    Spammer
    Join Date
    01-09-2011
    Location
    Colombo
    MS-Off Ver
    Excel 2007
    Posts
    116

    Need help on IF formula

    I have seen people in this forum helping each other in solving their issues which is very good for people like us who are stuck in finding solutions. I also have request on IF formula. I am designing a price table based on USD VALUE.

    I want the results to appear in column "C" based on the application which is shown from A12:A19. Example:-

    1) If the USD VALUE IS LESS THAN OR EQUAL TO 5, THEN WE NEED TO APPLY 150% (5*150%)
    2) If the USD VALUE IS BETWEEN 6-10, THEN WE NEED TO APPLY 120%

    I tried formulating but didn't work. My results are appearing in Column E2:E9

    Please help me.
    Attached Files Attached Files

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