Thread: Need help with end results Microsoft Office Excel 2003
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Need help with end results Microsoft Office Excel 2003
Try this:

=((D4<8.99)*0.3+0.25)*D4


" wrote:

=IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D48.99,"* 55%*")))
my answer =25%.

I need the answer to go a step further and multifply the cell by the %
what do I need to add to the formula to get my answer?

Reply With QuoteReply With Quote