hi
first, your formula is confusing, on really reflecting you discriptive need.
try this. in B1 enter this formula
=IF(A1<=49.95,12.48,A1*0.5)

if i got confused, post back.
and remember....formulas return values to the cell in which they reside.
they cannot put values in other cells or perform any other action.

Regards
FSt1


"ADC76" wrote:

Hello,
Here's my problem: If A1 is less than or equal to 49.95, I need B1 to show
a result of 12.48. If A1 is greater than 49.95, I need B1 to multiply the A1
number by 50%.
Here's the formula I've been trying to use, but it isn't working the way I
need it to:
=IF(AND(A1<=49.95,B1=12.48,IF(A149.95,B1*0.5,0)))
I really don't know what I'm doing wrong. Any suggestions would be great.
Thanks,
ADC76