Many arguments to one cell

[Amortcal]

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.

 

[Aladin Akyurek]

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

 

[Amortcal]

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