View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Need help with end results Microsoft Office Excel 2003

Do you mean

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

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


" 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?