Need help with end results Microsoft Office Excel 2003

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

 

[Jacob Skaria]

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

 

[Ron Rosenfeld]

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

You also need to subtract some stuff:

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

 

[vivianl]

YES, thank you, thank you , thank you. I was about ready to give this up

 

[Teethless mama]

Try this:

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