Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Many arguments to one cell

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to develop a spreadsheet where the user will enter different values in two cells. Example 1000 in Sheet1 cell A1 and 1200 in Sheet1 A2.

    I want to be able to automatically have a value entered in cell B1 on sheet 2 depending on whether:
    sheet1 cell A1 is greater than sheet1 cell A2 (100 entered in sheet2 cell B1),
    Sheet1 cell A1 is less than sheet1 cell A2(zero entered in cell sheet2 B1)
    or Sheet1 cell A1 is equaled to sheet1 cell A2 (50 entered on sheet2 cell B1).

    I tried using IF statement to do this but had no luck. I think maybe a macro would be the better thing to use. If anybody can help with a macro I would be very appreciative.

    Thanks.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,647
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-12 12:27, Amortcal wrote:
    I'm trying to develop a spreadsheet where the user will enter different values in two cells. Example 1000 in Sheet1 cell A1 and 1200 in Sheet1 A2.

    I want to be able to automatically have a value entered in cell B1 on sheet 2 depending on whether:
    sheet1 cell A1 is greater than sheet1 cell A2 (100 entered in sheet2 cell B1),
    Sheet1 cell A1 is less than sheet1 cell A2(zero entered in cell sheet2 B1)
    or Sheet1 cell A1 is equaled to sheet1 cell A2 (50 entered on sheet2 cell B1).

    I tried using IF statement to do this but had no luck. I think maybe a macro would be the better thing to use. If anybody can help with a macro I would be very appreciative.

    Thanks.
    In B1 in Sheet2 enter:

    =(Sheet1!A1>Sheet1!A2)*100+(Sheet1!A1=Sheet1!A2)*50

    will probably suffice.

    [ This Message was edited by: Aladin Akyurek on 2002-05-12 12:37 ]

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you Aladin Akyurek, it works well. Really appreciate your help.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •