You mean A1*.5 right?. Formula in B1

=IF(A1<=49.95,12.48,A1*0.5)

If this post helps click Yes
---------------
Jacob Skaria


"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