Need formula to give whole number

  • Thread starter Thread starter vince
  • Start date Start date
Try this in E18.

=(IF(E17<=250,E17*1.25,IF(E17>=500,E17*1.5,E17*1.35)))

need to format E18 as currency with two decimals.

regards
Bill K
 
as you were

enter in e18

=(IF(E17<=250,E17*0.25,IF(E17>=500,E17*0.5,E17*0.35)))

to show the percentage only and not E17 plus the percentage
regards
Bill K
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The Dead Horse 1
formula help 5
Lookup_finding all the corresponding cell... 5
FOrmula Copy and Paste 3
Sum formulas 3
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
putting number against certain words formula 0
Random Whole Number Functions 3

Back
Top