Thread: Trying to calculate results in one cell, based on data of another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ADC76 ADC76 is offline
external usenet poster
  
Posts: 19
Default Trying to calculate results in one cell, based on data of another
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
Reply With QuoteReply With Quote