That seems to work great. But, now I realize that I want the B1 cell blank
unless there is data entered in the A1 cell. 12.48 is in the B1 cell all the
time now.

"Jacob Skaria" wrote:

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