Need help with end results Microsoft Office Excel 2003

  • Thread starter Thread starter vivianl
  • Start date Start date
V

vivianl

=IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D4>8.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?
 
Do you mean

=D4*IF(D4<8.99,55,IF(D4=8.99,25,IF(D4>8.99,55)))%

If this post helps click Yes
 
=IF(D4<8.99,"*55%",IF(D4=8.99,"*25%",IF(D4>8.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?
Click to expand...

You also need to subtract some stuff:

=D4*IF(D4<8.99,55%,IF(D4=8.99,25%,IF(D4>8.99,55%)))
--ron
 
Back
Top