Buying Excel work

Discussion in 'Programming' started by and_y, May 11, 2013.

0
  1. #1
    Hello, looking for expert coder that has experience with excel macro programming.

    I have 3 columns and will need

    Column1+35%=Result ; if Result is higher then Column2 print Result on column3
    otherwise print Colum2 also the color cell must change depending on result.

    Example:

    Column1 Colum2 Column3
    0.49+35% 0.49 0.66

    Please send PM for quote, please don't ask my budget :)

    Thanks
     
    and_y, May 11, 2013 IP
  2. optimizare

    optimizare Active Member

    Messages:
    507
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    60
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Formula for A3 is:
    =IF((A1+35*A1/100)>B1;(A1+35*A1/100);B1)
     
    optimizare, May 11, 2013 IP
  3. and_y

    and_y Active Member

    Messages:
    287
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    As Seller:
    100% - 0
    As Buyer:
    100% - 4
    #3
    Thanks optimizare! Tested but seems is not working
     
    and_y, May 11, 2013 IP
  4. tandac

    tandac Active Member

    Messages:
    337
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    IF((A1*1.35)>B1;(A1*1.35);B1)
    Sounds like a school assignment to me as this is pretty trivial. Coloring the cell is left as an exercise. ;)
     
    tandac, May 11, 2013 IP
  5. and_y

    and_y Active Member

    Messages:
    287
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    As Seller:
    100% - 0
    As Buyer:
    100% - 4
    #5
    LOL :D
     
    and_y, May 11, 2013 IP
  6. optimizare

    optimizare Active Member

    Messages:
    507
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    60
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    and_y, it works just fine for me:

    Here is a screenshot: proof-for-dp.jpg

    If it still doesn't work for you feel free to send me your excel file via PM and I'll check it out free of charge
     
    optimizare, May 12, 2013 IP
  7. and_y

    and_y Active Member

    Messages:
    287
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    As Seller:
    100% - 0
    As Buyer:
    100% - 4
    #7
    A= AG
    B= AH
    C= AF

    Thanks!
     
    Last edited: May 12, 2013
    and_y, May 12, 2013 IP
  8. and_y

    and_y Active Member

    Messages:
    287
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    As Seller:
    100% - 0
    As Buyer:
    100% - 4
    #8
    Hi, work is still open :)
     
    and_y, May 12, 2013 IP
  9. tandac

    tandac Active Member

    Messages:
    337
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #9
    My quote to do finish this Excel sheet off for you is $100. I'll need a copy of the spreadsheet and payment via paypal 50% up front.
     
    tandac, May 13, 2013 IP
  10. genchev

    genchev Well-Known Member

    Messages:
    541
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #10
    =IF(A1*1,35>B1;A1*1,35;B1)
     
    genchev, Jun 3, 2013 IP