Text label and value if value in other worksheet is > 0

Closed
fixradio Posts 4 Registration date Friday December 19, 2014 Status Member Last seen December 23, 2014 - Dec 19, 2014 at 12:14 PM
can anyone help me with a formula for this.

Text label and value, if value in other worksheet from 2 different cells is > 0, label based on witch cell is > 0.

Examples
IF sheet1 A1 is blank, cell B1 is blank then sheet2 cell E1= blank, no value or text
IF sheet1 A1=$2.00, cell B1 is blank then sheet2 cell E1= Discount $2.00
IF sheet1 A1 is blank, cell B1=$2.00 then sheet2 cell E1= Rebate $2.00