+ Reply to Thread
Results 1 to 2 of 2

how can we put these conditions in formula?

  1. #1
    Registered User
    Join Date
    12-10-2006
    Posts
    35

    how can we put these conditions in formula?

    hi guyz how are u hope u will be fine and enjoy the life
    A B C D
    2 5 1% 100000
    4 6 2% 200000

    i want to make a formula which show me when d 100000 greater then or equal to 2 and b equal to and greater then 5 then it show me 1% in e colume other wise show me 0

    and
    if a=> 4 and 6=> 200000 then show me 2% in e colum plz letme know how can i sort it out with the help of formula

    thanks in advance

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: how can we put these conditions in formula?

    Your post is not very clear I'm afraid... if you have only a handful of tests:

    =IF(AND(A1>=4,B1>=6,D1>=200000),2%,IF(AND(A1>=2,B1>=5,D1>=100000),1%,0%))

+ Reply to Thread

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